D
DMW
The formula below will return a GPA for our salespeople
=IF(H7>0.9,4,IF(H7>=0.8,3,IF(H7>=0.7,2,IF(H7>=0.6,1,0)))), but I need to add
one more criteria and that if another cell (C4) = 0 then the results of this
formula need to be 0 as well.
I hope this makes sense, can someone please help me.
Thanks!
=IF(H7>0.9,4,IF(H7>=0.8,3,IF(H7>=0.7,2,IF(H7>=0.6,1,0)))), but I need to add
one more criteria and that if another cell (C4) = 0 then the results of this
formula need to be 0 as well.
I hope this makes sense, can someone please help me.
Thanks!