=If(C4 = 0, 0, IF(H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,IF(H7=0.6,1 ,0)))))
--
HTH...

Jim Thomlinson


"DMW" wrote:

The formula below will return a GPA for our salespeople
=IF(H70.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!