If values in 2 cells matches criteria, add text to a third cell

Have an issue with client orders. We need to add text to a cell if print orders are over a certain dollar amount and printed on a specific paper.

So, say cell A1 is photo and cell A2 is 20.00.

The macro would need to add "XL" to a new cell if A1 = photo and A2 is = or > 20.00.

Probably simple, but I'm stumped.

Try this
= IF(AND(A1="photo",A2>=20),"XL","")

Thanks. Forgot to mention, this code will need to function within an existing, written macro that reformats the orders. This needs to be a new command line within that macro. Is this format designed for use within a cell in the worksheet?

We get orders in and run a macro on them to reformat. Sorry if I'm not explaining this well.

Maybe you can provide the code here and try and help us locate the step where the above formula can be put in.

I wish I could. But it's considered proprietary intellectual property and I can't post it.

Thanks for your help though. We'll figure it out.

Originally Posted by prizm

Try this
= IF(AND(A1="photo",A2>=20),"XL","")

Maybe in the lines of the formula above, if you need to apply it in code you can use the IF loop -

Please Login or Register  to view this content.

Just change the cell references where required.