View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael in Georgia Michael in Georgia is offline
external usenet poster
 
Posts: 1
Default How do I use functions and calculations?

I'm having trouble with this conditional, nesting, logic and calculating
scenario.

If x is less than 500, then "$500." If x is between 500.01 and 650, then
"$650. If x is greater than 650, then "$650."

--Michael Manning