greater than less than if formula.... stumped :P

a1 = quantity
a2 = $20.00
a3 = (the cost of a1*a2 if more than 2500.00. If less than 2500.00 than 2500.00. but if a1 is zero i want a3 to remain zero, not 2500.00)

i tried it like ten different ways i cant figure it out, but i am certainly no excel expert :D anyone needs help with backup vocals for karaoke? im your man

Try

=IF(A1=0,0,MAX(2500,A1*A2))

HAHA JONMO1 you frikken awesome human. lifesavor. thank you so much

You're welcome