Question about Computers & Internet

Excell check the value of a cell if it's greater than zero then add the value of that cell plus a number and return it to another cell.

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Expert

=if(B2>0,B2+20,0)

in this case if the value of cell B2 is greater than 0, the value will be added to 20, if its less than zero it will return the answer 0.

Posted on Mar 14, 2008

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

× Related Questions:

I get an error when I tally cells that have errors because of dividing empty cell by empty cell.

Hi I dont really have much to do with Excel as I essentially build and repair and install, gosh I still type with two fingers!! Now below I have provided a link to Microsoft . Ways to count values in worksheets etc. If the problem persists try to update Office with what ever sercice packs are required and see if this helps. the link is http://office.microsoft.com/en-au/excel-help/ways-to-count-values-in-a-worksheet-HA010287849.aspx and I do hope it helps.
Cheers

Oct 28, 2011 | Microsoft Excel for PC

How do you represent the set of rational numbers in symbol form

hi maybe the formula below will help you

A rational number is a number that can be expressed as a fraction with an integer numerator and a non-zero natural number denominator. Fractions are written as two numbers, the numerator and the denominator, with a dividing bar between them. In the fraction written mn or m represents equal parts, where n equal parts of that size make up one whole. Two different fractions may correspond to the same rational number; for example 1⁄2 and 2⁄4 are equal, that is: If the absolute value of m is greater than n, then the absolute value of the fraction is greater than 1. Fractions can be greater than, less than, or equal to 1 and can also be positive, negative, or zero. The set of all rational numbers includes the integers, since every integer can be written as a fraction with denominator 1. For example −7 can be written −7⁄1. The symbol for the rational numbers is Q (for quotient), also written .

Jun 27, 2010 | Cobra 29 LTD CB Radio

Casio fx-7400G PLUS cubic solver?

Hi,
First let us repair the terminology.

1. You can evaluate any expression (find the value of any expression for a particular value of its variable).Store a value in the variable, say X. Key in the expression and press [EXE].
2. You can consider your expression(should not contain a relational operator such as =, greater than, less than, greater than or equal to, less than or equal to) to be a function Y1(x) = expression and graph it, or generate a table for it. You will have several values of the function calculated at various points.
3. You can set your expression equal to 0 and find the particular value(s) of the variable (the unknown) that make the equality TRUE. That is called solving an equation.
I am not sure that it has a solver (solving an equation or an inequation) but you can always draw your expression as a function and explore the graph (SKTCH) to locate the roots (or zeros) of the functions (the values of the variable where the function equals zero.) That is called solving graphically.

Hope it helps.
Thank you for using FixYa and for rating this solution.

Nov 05, 2009 | Casio FX-7400G Plus Calculator

Excel Formula

With data in A1 to C1: A2 =IF(A1>0,1,0) B2 =IF(B1>0,1,0) C2 =IF(C1>0,1,0) A3 =SUM(A2:C2)

Jun 04, 2009 | Microsoft Office Excel 2007

Macro code for copying a range of cells from one Excell w/sheet t

You did not respond to my claification request. Here is some code that might help, it copies a selection of cells going down until an emty cell is found and across until an emty cell is found. This is form an earlier version of office but should comeclose to woring in 2007.

Sub copyrange()
'
' copyrange Macro
' Macro written by Royal 11/22/2008.
'

'save the return values
wksname = ActiveSheet.Name
searchfor = ActiveCell.Value

'go to first worksheet and find entered value (note this is a value serach)
Worksheets(1).Activate
findfor = "A1"
On Error Resume Next

findfor = Cells.Find(What:=searchfor, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
If findfor = "A1" Then
erwks = ActiveSheet.Name
Sheets(wksname).Activate
er = MsgBox("Search item not found on Worksheet" + erwks, , "Search Error")
Exit Sub
Else
findfor.Activate
End If

Cells.FindNext(After:=ActiveCell).Activate

'save this address and start searching for copy area boundaries
begcl = ActiveCell.Cells.Column
begri = ActiveCell.Cells.Row
'search amaximum of 1000 rows and 676 columns
endri = begri + 1000
endcl = 26 * 26
maxrow = 0
maxcol = 0

For col = Cells.Column To endcl
If Cells(begri, col) = "" Then
maxcol = col
col = endcl
ri = endri
Else
ri = begri
End If
For ri = ri To (Cells.Row + 1000)
If Cells(ri, col) = "" Then
If ri > maxrow Then
maxrow = ri
End If
ri = endri
End If
Next ri
Next col

maxrow = maxrow - 1
maxcol = maxcol - 1

'copy the selected area
endcell = Cells(maxrow, maxcol).Address
crnge = begcell & ":" & endcell
Range(crnge).Select
Selection.Copy
'go back and paste it in
Sheets(wksname).Activate
Range(returncell).Select
' use this if yo want to paste formulas etc.
'ActiveSheet.Paste
' use this code if you want to paste values instead of formulas etc.
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range(returncell).Select

Nov 20, 2008 | Computers & Internet

HLOOKUP IN MS EXCEL

lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Computers & Internet

Ean 13 problem

you are probably reading to a inteligent software package like Excell, which sees the inputted data as a number (so ignores leading zeros) you need to specify to the sytem that the incoming numbers are TEXT not numbers.

Sep 30, 2008 | Symbol LS2208 Handheld

Functions

The eomoth function returns the last day of the month.
Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

eomonth (1/2/08, 1) will return 31. The number of days in the month.

eomonth (1/2/08, 2) will return 59, The number of days in the month plus the next month (February)

Mar 06, 2008 | Microsoft Excel for PC

Excel 2002 formula

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Computers & Internet

Open Questions:

Related Topics:

91 people viewed this question

Usually answered in minutes!

Level 3 Expert