Formula help
 

I'm in Cell AA25: and need to access the data in cell O25 in a way that IF
cell O25: =1 then insert $130.00 or IF cell O25: =2 then insert $240.00 or
if O25: is blank leave AA25 blank. Any assistance is greatly appreciated.

--

Regards
Michael Koerner

Formula help
 

Hi Michael,

=if(O25=1,130,If(O25=2,240,""))

HTH
Carim

Formula help
 

=IF(O25=1,130,IF(O25=2,240,0))

=IF(O25=1,130,IF(O25=2,240,IF(O25="","",0)))

Formula help
 

Thanks to all, worked perfectly

--

Regards
Michael Koerner


"simon" wrote in message
oups.com...
| =IF(O25=1,130,IF(O25=2,240,0))
|
| =IF(O25=1,130,IF(O25=2,240,IF(O25="","",0)))
|

Formula help
 

Hi Michael,

=If(O25=1,130,if(O25=2,240,""))

HTH
Carim