Need a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula needed 4
Column Heading on each row in pivot table 1
Formula??? 8
How to dynamically add up varying # of cells base on a value 12
Determine next level from a table 2
Formula help (Lookup) 6
Help with formula 1
How identify data of two coulams,Every cell count and show result 1

Back
Top