Hello all,
I'm trying to make one formula to assign, A, B or C depending on the dollar value in a cell. I can write the formulas separately but putting them together I'm really confused
A:> $516,800: 80%
B: $183,116 – $516,800 : 81%-95%
C: < $183,116: 96% - 100%
=IF(B2:B2>516800,"A")
=IF(AND(B2>183116,B2<516800),"B","C")
How can I consolidate these two formulas to one
I'm trying to make one formula to assign, A, B or C depending on the dollar value in a cell. I can write the formulas separately but putting them together I'm really confused
A:> $516,800: 80%
B: $183,116 – $516,800 : 81%-95%
C: < $183,116: 96% - 100%
=IF(B2:B2>516800,"A")
=IF(AND(B2>183116,B2<516800),"B","C")
How can I consolidate these two formulas to one