Excel - IF Functions

  • Thread starter Thread starter Egirl
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum using more than 6 nested IF functions 3
IF function not calculating 3
Nested IF function 3
Create logic functions like a flip-flop in excel? 1
Functions 1
nesting functions to compare segments of two columns 1
Named Range question 9
Split a worksheet into multiple worksheets of the same Excel file 1

Back
Top