Excel formula's

K

ketchumbass

I am trying to create a complex formula and not sure how to do it. Hoping
that someone here can help. If a cell contains "1st" then I need that to
convert into "300" in another cell and spreadsheet. Any idea's on how to
create this formula?
Thanks
 
H

Harald Staff

Hi

If your sheet is named Sheet1 and the cell in question is A6 :

=IF(Sheet1!A6="1st",300,18)

HTH. Best wishes Harald
 
Top