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?