Need a formula

A

audi

If N9=1 2 3 or 4 then I would like cell O9 to = 400, 500, 600, 700

1=400
2=500
3=600
4=700

PLEASE ADVISE, THANKS
 
E

Excel Man

THIS IS THE FORMULA NEEDED IN CELL O9
=IF(N9=1,100,IF(N9=2,200,IF(N9=3,300,IF(N9=4,400,""))))

DO YOU KNOW HOW TO CREATE AUTO NUMBERING FOR INVOICES SO THAT EACH TIME I
OPEN MY INVOICE TEMPLATE THE NEXT NUMBER AUTOMATICALLY POPS UP???
THANKS
 
Top