It looks like if you're saying if it's less than 500, then 500, otherwise 650.

=if(a1<500,500,650)
or maybe:
=if(a1<=500,500,650)

Depending on what happens at exactly 500.


Michael in Georgia wrote:

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

--

Dave Peterson