Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only want formula to show up if a1 is not blank
Hi
I have this formula in excel: =I2*0.024+0.2 which gives me 2.4% plus 0.20 of column i2 But if i2 is blank -0.20 shows up but I dont want it to show up if i2 is blank. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make cell show blank when total is zero | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
How to show the formula of another cell | Excel Worksheet Functions | |||
How to get a formula result zero as blank cell | Excel Discussion (Misc queries) | |||
Want #VALUE! to show as blank cell | Excel Worksheet Functions |