If, instead of A1, you want the function to return an empty string "", then
change
=IF(AND(A1100000,A1<200000),A1*0.25,A1)
to
=IF(AND(A1100000,A1<200000),A1*0.25,"")

If you want the formula to return something different if the condition isn't
met, then put that after the second comma, instead of A1 or "".
--
David Biddulph

"Go-go" wrote in message
...
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