2 conditions AND 5% discount

[MagM]

Q1. Using the IF calculate, IF days hired are over 7 AND the cost is over €120 apply 5% discount. =IF(AND(B17>120,D13>120,)5%,0) I got a false reply. Also does the answer have to be in Currency or %? A silly question I know but I'm a bit unsure! Thanks for any help please.

 

[jeffreybrown]

Hello & Welcome to the Board,

Not exactly sure what you are doing...I don't see the over 7 you mentioned, but anyway, the proper formula would be...

=IF(AND(B17>120,D13>120),5%,0)

 

[MagM]

Thanks v much for replying. Sorry I did it wrong. What I meant to say is, Days hired over 7 and cost is over €120 give a 5% discount. Hope this makes sense

 

[jeffreybrown]

Are you saying this resolves your problem or is there still something unresolved?

 

[MagM]

Yes Jeffrey, I followed your formula and discovered I had a comma in the wrong place! Brilliant, thank you so much

 

[jeffreybrown]

You're welcome...glad to have helped