Forum Discussion
Converting a letter into a dollar amount
I am trying to set a excel document that will allow me to convert an X in a cell into a dollar amount in another cell. I would like to place an X in a cell in a column so that I don't have to keep t...
=IF(A1="X", your_dollar_amount, "")
This formula checks if cell A1 contains an "X". If it does, it will display the dollar amount you specify. If there's no "X", it will display nothing (""), leaving the cell blank.
Drag this formula down along Column B, and it will adapt for each row based on the "X" or empty cell in Column A.
This formula checks if cell A1 contains an "X". If it does, it will display the dollar amount you specify. If there's no "X", it will display nothing (""), leaving the cell blank.
Drag this formula down along Column B, and it will adapt for each row based on the "X" or empty cell in Column A.
Thank you.