Forum Discussion
Use formula depending on cell input
Hello, I al trying to create a new excel sheet where I want the cell to use a formula when the user did not input a number and to ignore the formula when the user has input a number. Hopefully I ...
Hi boJob
You can use a formula to achieve this, however, you will need to provide additional information to know what you want the formula to do.
if you can share a sample data, it will be useful.
Cheers
I want the cell to use this formula "=C3*B13" when the user hasn't put any data in, otherwise I want it to use the data the user has put in for example "400". Hope this helps
- ok. Because you didn't indicate the cell where the user input will be and where the formula will be, I will assume the following.
The user input is in cell A1 and the formula is written in cell A2, then you can use this formula:
=IF(A1="",C3*B13,A1)
Cheers
