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?

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

Try this - I assume C1 has the value to work on
=IF(C1100,65,IF(C150,70,C1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Da Bossman" <Da wrote in message
...
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?

On Aug 9, 7:48 am, Da Bossman <Da
wrote:
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(C1100, 65, if(C150, 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.

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

"Da Bossman" <Da wrote in message
...
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?

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

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

Format/ Cells .../ Number tab/ Currency
--
David Biddulph

"Da Bossman" wrote in message
...
Yes, thank you Toppers. Is there a way I can make it currency?

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

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?