| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula help: IF a cell has any number in it.....
nvm, fixed it myself. Used ISBLANK, so that if the cell was empty, then it
would do one calculation, if cell was not, it would do second calculation. "HowlingBlue" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula help: IF a cell has any number in it.....
You could have used ISNUMBER( ).
Pete On Mar 16, 7:36 pm, HowlingBlue wrote: nvm, fixed it myself. Used ISBLANK, so that if the cell was empty, then it would do one calculation, if cell was not, it would do second calculation. "HowlingBlue" wrote: 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!- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula help: IF a cell has any number in it.....
=IF(ISBLANK(D5),C5+B3,D5+B3)
Regards, Alan "HowlingBlue" wrote in message ... 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! |
| Reply |
| 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 | |||
Linear Mode
