Can you help nesting a formula?

[Guest]

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?

 

[Guest]

=if(c1>100,65,if(c1>50,70,75))

 

[Bernard Liengme]

Try this - I assume C1 has the value to work on
=IF(C1>100,65,IF(C1>50,70,C1)
best wishes

 

[joeu2004]

I'm nesting a formula but I'm getting an error.

Post your formula here.

My column starts
at $75 and needs to drop to $70 if column C is >50 and
$65 if >100. Can someone please help?

You are not explaining your requirements very well. Perhaps this will
help:

=if(C1>100, 65, if(C1>50, 70, 75))

That sets the cell containing the formula to 65, 70 or 75 depending on
the value of C1. If you put the formula into D1 and copy-and-paste
(or drag) it down the column, it will make D2 depend on C2, D3 on C3,
etc.

 

[David Biddulph]

Tell us *what* error you're getting, and what your formula is, and then we
may be able to help you.

 

[Guest]

Yes, thank you Toppers. Is there a way I can make it currency?

 

[David Biddulph]

Format/ Cells .../ Number tab/ Currency

 

[Guest]

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.