Thread: Formula needed
View Single Post
  #1   Report Post  
audi
 
Posts: n/a
Default Formula needed

Please advise how I can come about a formula for the following.

If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700

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

Thank you in advance for your help.
Audi