Formula help needed urgently!

[Josdee]

Hi, any help on this one will be really appreciated!!!

I am trying to create an “if” formula with multiple arguments. I keep getting #NAME? and #VALUE! Errors. The logic of what I’m trying to input is as follows:

IF B57*B27>=B46 and B63<B57 then B72 applies, however if B63>B57 then {B72*{(( B57*B27)-B46)/(((B63*B27)- (B57*B27))+(( B57*B27)-B46))}-B75-B76

Where:
B27 = 15
B46 = 16 (variable)
B57 = 3
B63 = 3 (variable)
B72 = 188.69 (variable)
B75 & B76 will only have a value if B63>B57

I’ve already spent hours on this one please HELP!!!

Thanks
Dee

 

[Josdee]

You're a star!! Thanks Roger at least I'm on the right track now. Good luck with your help req.

Regards,
Dee

 

[Halebop]

Thanks! I'm off to bed. Its been a long day.