| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if/then statement
I am attempting to add a value of "1" to the output of a formula from a
different cell. However, if the the value of the other cell is "0", I do not want the "1" added. I need to have a correlating "0" with the other "0". Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if/then statement
Hi,
Maybe something like this: =SUM(A1:A10)+IF(B1=0,0,1) HTH Jean-Guy "PoolPool" wrote: I am attempting to add a value of "1" to the output of a formula from a different cell. However, if the the value of the other cell is "0", I do not want the "1" added. I need to have a correlating "0" with the other "0". Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if/then statement
If you mean have a formula that displays 1 more then the output of another
cell or zero if the other cell is zero then try: =if(Othercell<0,Othercell+1,0) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "PoolPool" wrote in message ... I am attempting to add a value of "1" to the output of a formula from a different cell. However, if the the value of the other cell is "0", I do not want the "1" added. I need to have a correlating "0" with the other "0". Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF/then statement help..... | Excel Worksheet Functions | |||
| If/Then Statement | Excel Worksheet Functions | |||
| if/then statement that results in Yes/No | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| If/Then statement | Excel Discussion (Misc queries) | |||
Linear Mode
