ExcelBanter - Excel formula's

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel formula's (https://www.excelbanter.com/excel-discussion-misc-queries/252116-excel-formulas.html)

ketchumbass

Excel formula's

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

Harald Staff[_2_]

Excel formula's

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

All times are GMT +1. The time now is 07:06 PM.