| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statment
Gord Dibben wrote:
=IF(G44=0,H44) returns H44 value if G4 is 0 Are you sure g44 is 0 or just formatted to show whole number? Maybe value is 0.0000000012 or similar? What happens when you use this formula? =IF(G44=0,H44,"not zero") Gord Dibben MS Excel MVP If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) Thank you the value was wrong. I thought I had the formula right but sometimes you just need and outside look. Thank you againe now it works. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with If statment | Excel Discussion (Misc queries) | |||
| If statment | Excel Discussion (Misc queries) | |||
| if statment | Excel Worksheet Functions | |||
| If statment if its possible. | Excel Discussion (Misc queries) | |||
| If statment | Excel Worksheet Functions | |||
Hybrid Mode
