Need a formula
 

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

=CHOOSE(N9,400,500,600,700)
--
Gary's Student


"audi" wrote:

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

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

"audi" wrote:

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