View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HowlingBlue HowlingBlue is offline
external usenet poster
 
Posts: 3
Default 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!