Formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Koerner - 22 Mar 2006 18:06 GMT

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.

Signature

Regards
Michael Koerner

Reply to this Message

Carim - 22 Mar 2006 18:16 GMT

Hi Michael,

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

HTH
Carim

Reply to this Message

simon - 22 Mar 2006 18:28 GMT

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

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

Reply to this Message

Michael Koerner - 22 Mar 2006 19:28 GMT

Thanks to all, worked perfectly

Signature

Regards
Michael Koerner

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

Reply to this Message

Carim - 22 Mar 2006 19:39 GMT

Hi Michael,

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

HTH
Carim

Reply to this Message