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

Hi

=IF(B1,B1,C1)*2.25

--
Regards

Roger Govier


"Scooter" wrote in message
...
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.