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!
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!