IF formula

[alexm]

Hello,

I need help with an IF formula.

I've attached a file with an example and also info on the formula.

Any help would be greatly appreciated

Thx

[gringo287]

if ive read it correctly

[Teeroy]

The second IF statement in @gringo287's sample isn't required (if the first condition isn't true, the second condition must be) and it doesn't need to be an array formula (it's not wrong, just overly complex). You could simply use (in C4) =IF(E4>=D4,1.75,E4/D4*1.75/$E$2) and fill down.

[gringo287]

Cool, Cheers teeroy. That'll help me as well.

[Teeroy]

You're welcome Gringo. I've never logged into a forum and not learned something; we're always learning.

[gringo287]

Not sure if we've helped alexm yet though?..

[alexm]

Both formulas worked.

Thank you very very much.