View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Da Bossman[_2_] Da Bossman[_2_] is offline
external usenet poster
 
Posts: 1
Default Can you help nesting a formula?

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?