Hi

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

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

HTH. Best wishes Harald

"ketchumbass" wrote in message
...
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
--
ketchumbass