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 ...
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
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