I wanted to know if there is something quicker than using multiple if statements. I have a quote sheet for work were the estimator would plug in qty and types all linked ot a price on one tab/sheet. Then the client would see a quote with only the options the estimator has choosen.
I don't mid doing more research just wasn't sure if there is a different formula to do this.
I only have couple lines in the description area for the items selected on the previous tab. So the first line in the decription I would have to have
=if item 1 is empty then put item 2 if item 2 is empty then put item three. There are probably around 20 different items that can be selected and some are drop down items.
Any help would be greatly appreciated.