| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help: IF a cell has any number in it.....
I basically want to have a formula in a cell that will perform one
calculation if a certain cell is empty, but if that cell has a number in it, will perform a calculation on that cell. Anyone know how to do this? My idea was =IF(D5=(character for "any number"),D5+B3,C5+B3) Anyone have ideas on this? Thank you for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it a formula or a number in cell | Excel Worksheet Functions | |||
| Formula help, chaning a cell number within the formula | Excel Discussion (Misc queries) | |||
| in excell the cell only displays formula, not the number | Excel Worksheet Functions | |||
| Transform a Cell from Formula to Number | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Threaded Mode
