Using the IF AND Function in Excel

I have 2 criteria. If sales in a cell A1 are between 2500 and 4999.99, then in Cell B1 show 500, but if sales are greater than 4999.99 then show 1000

 

help?

One thought on “Using the IF AND Function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *