Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Modification
This formula works okay when cell U51 is either blank or
with data greater than zero; however, I now need to modify the formula for the case when cell U51 has a zero posted in it - so it returns a zero answer - with the other features still intact. =IF(U51<0,(U51-V42)/(P42-V42),"") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula modification | Excel Worksheet Functions | |||
Formula Modification | Excel Discussion (Misc queries) | |||
Formula Modification | New Users to Excel | |||
Formula Modification | Excel Worksheet Functions | |||
Formula Modification Help | Excel Worksheet Functions |