Forum Discussion
Help with IF formula
Hello all, I've been struggling to write an IF formula for my query below and was wondering if anyone could help. Is it even possible with an IF formula? I have the data in the screenshot be...
=IF(M4>=0.1, "Tier 3", IF(L4="#", IF(M4>=0.01, "Tier 2", "Tier 1"), IF(M4>0.01, "Tier 2", "Tier 1")))
or
=IF(M4>=0.1, "Tier 3", IF(M4>0.01, "Tier 2", IF(M4<0.01, "Tier 1", IF(L4="#", "Tier 2", "Tier 1"))))