Forum Discussion
Multiply by one cell or another cell
Hello, I'm making an invoice and there's two options I need. So in column A, I have a drop down for types of work. Once the type of work is selected I have data validation set up in column F for the ...
RyeBread808 Assuming that a 'type of work' either generates quantities OR hours at a certain price price. And that data validation populates either one or the other but never both, you could try this: