multiple IF statements in same cell

[wayneeustace]

Hi there

I need to return different results depending on the value of a cell.

Example:

In cell B1 and C1 there are standard numerical data.
In cell E1 there is a simple formula: =C1/B1 (with the returned value shown as %)

In cell F1 I need to return:

If D1="yes" then add 5% to the total of E1
If E1 <5% then "fail"
If E1 =>5% but <10% then "yes"
If E1 >10% then "no"

I've tried several different combinations but can't seem to get it work. Any assistance would be greatly appreciated.

Thank you.

 

[Special-K99]

Your IF E1 statements

Is that IF E1... with the 5% already added (cos D1="Yes")

or is that IF E1... if the D1="yes" fails ?

 

[Special-K99]

Try

IF(D1="Yes",E1*1.05,LOOKUP(E1,{0,0.05,0.1},{"Fail","Yes","No"}))