Struggling to get the three results on an IF OR statement

[brianaclark1967]

Hi all,

I've attached a quick sheet showing my problem.

I want to record 2.5% of two cells if the other cell states "Credit Card" or "Y", but I can't seem to add on the other result I need.

If the cell states "Debit Card" I want to get a result of 0.3%

The sheet will make it clearer

Thanks guys

Regards

Brian

 

[NARAYANK991]

Hi Brian ,

Something like this ?

=IF(OR(F4="Y",E4="Credit Card"),(G4+H4)*0.025,IF(E4 = "Debit Card", (G4+H4)*0.03, 0))

Narayan

 

[brianaclark1967]

Hi Brian ,

Something like this ?

=IF(OR(F4="Y",E4="Credit Card"),(G4+H4)*0.025,IF(E4 = "Debit Card", (G4+H4)*0.03, 0))

Narayan

Thank you Narayan,

That's awesome.

Really appreciate it

Regards

Brian