Something like:
=IF(C4=0,0,H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,IF(H 7=0.6,1,0)))))

Regards,
Fred

"DMW" wrote in message
...
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!