Forum Discussion
IF Formula with "then" being a cell
I'm trying to do an If- Then formula, however I'd like to select a cell as the "then" as we may be changing the data and I don't want to have to rewrite the formula every time. Is this possible and if so, how?
Thank you!
6 Replies
ChrisMendoza Thank you so much! I can't believe I didn't try that lol!
What would you like to have in the "then"? Can you give an example?
I'm trying to do an estimating sheet for Lineal feet/man/hour. Below is a snip-it of the sheet. I have the wall height as a drop-down list, and per that selection it changes what shows in the LinFt/Man/Hr column. As I have a running list of the averages below, I'd like the "then" to be the corresponding number to that height. If I can select the cell as the "then", I'm hoping that if the data in the cell changes it would automatically update.
