I need to create a two part formula
 

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!

I need to create a two part formula
 

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!

I need to create a two part formula
 

=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!

I need to create a two part formula
 

Hi,
=if(C4=0,0,IF(H70.9,4,IF(H7=0.8,3,IF(H7=0.7,2,I F(H7=0.6,1,0)))))

"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!

I need to create a two part formula
 

Let's say goodbye to IF for this one
First try
=LOOKUP(H7*10,{0,6,7,8,9},{0,1,2,3,4})*(C4<0)

But that throws up a 4 for H7 =0.9 and you have H70.9
How about
=LOOKUP(H7*10,{0,6,7,8,9.0000001},{0,1,2,3,4})*(C4 <0)
or
=(C4<0)*((H7=0.6)+(H7=0.7)+(H7=0.8)+(H70.9))
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"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!