hi!
how if the value is not numeric?this is my problem..if LN7,LN8,LN9 = LN..
if HP7,HP8,HP9=HP and so on..is there any solution?

Thanks for your help.

--
Regards,
Linda


"Toppers" wrote:

=if(c1100,65,if(c150,70,75))

"Da Bossman" wrote:

I'm nesting a formula but I'm getting an error. My column starts at $75 and
needs to drop to $70 if column C is 50 and $65 if 100. Can someone please
help?