Excel - IF Functions

E

Egirl

Is there any way to make a nested IF Function where one of the options is to
input your own value? Or, similarly, can the false value for an IF Function
be your own input?

Thank you for the help...I appreciate it.
 
P

Pete_UK

No, if you allow user entry to a cell containing a formula, the entry
will overwrite the formula. You could allow data entry into another
cell, and have your IF formula pick the data from there in the false
clause.

Here's an example:

=IF(B1="",A1,B1)

This checks B1 to see if it is not blank and if so it will return the
value from there (User entry), otherwise it will pick up the value
from A1.

Hope this helps.

Pete
 
Top