Thread: Quick formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Quick formula

try this
=IF(B10,B1,C1*2.25)

"Scooter" wrote:

I think I'm confusing "if" with "or"...please help. I want cell A to use the
value in cell B if there is one, otherwise I want cell A to use the value in
cell C and multiply it by 2.25. Pretty easy, but I can't seem to get it to
work.