Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Could you suggest a formula to look at the value of one cell and, if the
value of that cell is zero, look at the value of another cell and make a calculation? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
=IF(A1=0,B1+C1,"A1 IS NOT ZERO")
Vaya con Dios, Chuck, CABGx3 "sdmccabe" wrote: Could you suggest a formula to look at the value of one cell and, if the value of that cell is zero, look at the value of another cell and make a calculation? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
=IF(A1=0,B1*2,"")
Regards, Peo Sjoblom "sdmccabe" wrote: Could you suggest a formula to look at the value of one cell and, if the value of that cell is zero, look at the value of another cell and make a calculation? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Great, thanks. I think I should have siad the value of the first cell is
actually 00/00/0000 as a cell formated as a date field, and no date is provided. "Peo Sjoblom" wrote: =IF(A1=0,B1*2,"") Regards, Peo Sjoblom "sdmccabe" wrote: Could you suggest a formula to look at the value of one cell and, if the value of that cell is zero, look at the value of another cell and make a calculation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |