I have a similar scenario but can you please show me what that function would
look like if the conditions weren't met and I don't want the number to return
to A1?

"Pete_UK" wrote:

This raises a few other questions, such as what if sales are less than
or equal to 100,000 or greater than or equal to 200,000? But anyway,
you can try this, assuming the sales figure is in A1:

=IF(AND(A1100000,A1<200000),A1*0.25,A1)

This returns A1 if the conditions are not met.

Hope this helps.

Pete