Need to find the error in this formula

[Uzzal]

=IF(C28=OR("20'","20'H"),1580,2040)
for 20' or 20'H berth operator will charge 1580
& for 40' or 40'H they will charge 2040

My requirement is
when C28=20' or 20'H then E28 will be 1580
& when C28=40' or 40'H then E28 will be 2040
any support will be appreciated.

 

[Deepak]

nested if..

=IF(OR(C28="20'",C28="20'H"),1580,IF(OR(C28="40'",C28="40'H"),2040,0))

 

[Uzzal]

Thanks Deepak, Its awesome.

 

[Deepak]

Without if..

=OR(C28="20'",C28="20'H")*1580+(OR(C28="40'",C28="40'H")*2040)

 

[Khalid NGO]

Hi,

You have now various solutions provided by Deepak Sir.
I just want to add this (as per your question title)

IF(OR can not be written like this:
=IF(C28=OR("20'","20'H"),1580,2040)

you were near but you to do something like:
=IF(OR(C28={"20'","20'H"}),1580,2040)

Regards,

 

[Uzzal]

Thanks again @Deepak
& to you @Khalid NGO for your support.

 

[Deepak]

Hi,

You have now various solutions provided by Deepak Sir.
I just want to add this (as per your question title)

IF(OR can not be written like this:
=IF(C28=OR("20'","20'H"),1580,2040)

you were near but you to do something like:
=IF(OR(C28={"20'","20'H"}),1580,2040)

Regards,

@Khalid NGO Just realized , i missed that array part.

Excel is excellent in itself, sometimes with a small liberty; we have couple of awesomeness to joy!

 

[Deepak]

Thanks again

Just found that you are not availing the like button placed at the right bottom of the each post!

It's placed to hit when that post did for you!

 

[Uzzal]

I found it, thanks