Excel Formula for Nested IF

[McNeil87]

Hello!

Am trying to write out a nested IF formula (if that's the best approach). This is what i have so far, but, I do not think it is correct.

=IF(I14>F14,"Ahead of Target","Behind Target"),IF(O8>=1,"Target Achieved","Target Not Achieved")

Any suggestions?

Thanks as always!

 

[gordsky]

Hello!

Am trying to write out a nested IF formula (if that's the best approach). This is what i have so far, but, I do not think it is correct.

=IF(I14>F14,"Ahead of Target","Behind Target"),IF(O8>=1,"Target Achieved","Target Not Achieved")

Any suggestions?

Thanks as always!

the formula wouldnt work as is effecitvely 2 seperate formula. what is it you want to achieve.

 

[Joe4]

You need to determine your order of events/things to check.
It appears that you have three cells that you want to look at I14, F14, and O8.
Which one should it check first/last?

 

[McNeil87]

You need to determine your order of events/things to check.
It appears that you have three cells that you want to look at I14, F14, and O8.
Which one should it check first/last?

the formula wouldnt work as is effecitvely 2 seperate formula. what is it you want to achieve.

Right, they are two separate formulas. Is it possible to combine the two into one? Essentially, i want to say if I14>F14, "Ahead of target", else "Behind", OR, IF cell N8>=1, then "Target Achieve", else Target Not achieved." Maybe it's a type of formula best not to combine? Order of operations would be to look at cells I14 to F14, then O8. thanks!

 

[gordsky]

Right, they are two separate formulas. Is it possible to combine the two into one? Essentially, i want to say if I14>F14, "Ahead of target", else "Behind", OR, IF cell N8>=1, then "Target Achieve", else Target Not achieved." Maybe it's a type of formula best not to combine? Order of operations would be to look at cells I14 to F14, then O8. thanks!

I dont think that would work because I14 is either going to be TRUE (greater and = AHEAD) or FALSE(less and equal Behind).
The only way it would move to the OR look at N8 would be if I14=F14.

 

[McNeil87]

I dont think that would work because I14 is either going to be TRUE (greater and = AHEAD) or FALSE(less and equal Behind).
The only way it would move to the OR look at N8 would be if I14=F14.

Right -- thank you!

 

[Joe4]

They could all be put into one formula, but then not it will only return one value, and it appears that you are checking two totally unrelated conditions.

So, based on your criteria, I see 6 different combinations. If you can tell us what you want to return in each situation, we can help you come up with a formula to do that:

Condition 1	Condition 2	What to return?
I14 > F14	O8 >= 1
I14 > F14	O8 < 1
I14 = F14	O8 >= 1
I14 = F14	O8 < 1
I14 < F14	O8 >= 1
I14 < F14	O8 < 1

 

[McNeil87]

They could all be put into one formula, but then not it will only return one value, and it appears that you are checking two totally unrelated conditions.

So, based on your criteria, I see 6 different combinations. If you can tell us what you want to return in each situation, we can help you come up with a formula to do that:

Condition 1	Condition 2	What to return?
I14 > F14	O8 >= 1
I14 > F14	O8 < 1
I14 = F14	O8 >= 1
I14 = F14	O8 < 1
I14 < F14	O8 >= 1
I14 < F14	O8 < 1

It's okay - i will stick with separate formulas. thank you both for your help

 

[Joe4]

Since you went with the multiple formulas approach, I changed your marked solution to Gordsky's reply that mentioned that.