IF formula checking

[Stu.martin01]

I need an IF formula which deals with uses data in 3 cells to produce a formula in another

this is what i have come up with so far

=IF(E5=0,"IF(D4>=61.3,"14.9-(1.5*D10)","14.6-(1.5*D10)")","IF(D4>=75,"15.7-(1.5*D10)","15.1-(1.5*D10)")")

therefore cell E5 will be either 0 or 1, IF E5=0 and weight is greater than 61.3 then the formula which needs to appear in the cell is
"14.9-(1.5*D10)"

if someone could help me correct this formula i would really appreciate it

thanks

stu

[Jacc]

I don't understand, do you want the formulas or a text string of the formulas? Anyway, if you want the formulas it should look more like this:

Please Login or Register  to view this content.

[Ace_XL]

Perhaps..

=IF(E5=0,IF(D4>=75,15.7-(1.5*D10),IF(D4>=61.3,14.9-(1.5*D10),"")),"")