Need help with an Excel IF formula

[DiscoStu]

I'm just more concerned you're trying to do something else here than meets the eye If there are values already on the sheet you want to preserve, you'll need to put your IF somewhere else to avoid overwriting them. Generally it's not a good idea to let your users overwrite your formulas (you should lock them) - give them an input area for data, then lock your calculated fields.

It's OK, it's just my brother trying to avoid a load of data entry, I'll make sure he backs up before he inserts the formula.

[TheBigYinJames]

I guess you're right, thanks James!

I'm just more concerned you're trying to do something else here than meets the eye If there are values already on the sheet you want to preserve, you'll need to put your IF somewhere else to avoid overwriting them. Generally it's not a good idea to let your users overwrite your formulas (you should lock them) - give them an input area for data, then lock your calculated fields.

[Badger]

Maybe you need to turn this around and check for the user entry first, two columns for this to work, with the IF function checking for user entry and the original check. Something like:

IF(A1<>"", "", IF(B1="ABC", "DEF", ""))

[DiscoStu]

Well why worry if it's blank beforehand then?

I guess you're right, thanks James!

[TheBigYinJames]

Yes, pretty much.

Well why worry if it's blank beforehand then?

[DiscoStu]

As soon as you put an IF statement in there, that is what is in the cell. It can't be 'any number of values' - it has to be the IF statement.

So you want your user to overwrite your IF formula by typing into it?

Yes, pretty much.

[TheBigYinJames]

It could be any one of a number of different values, all of which will be entered by hand, which is why I don't want it to go blanking them.

As soon as you put an IF statement in there, that is what is in the cell. It can't be 'any number of values' - it has to be the IF statement.

So you want your user to overwrite your IF formula by typing into it?

[DiscoStu]

You can't 'do nothing' because by definition you have your IF statement in the cell. All you can do is change what the IF produces. What's wrong with a blank? What do you want it to be instead?

It could be any one of a number of different values, all of which will be entered by hand, which is why I don't want it to go blanking them.

[TheBigYinJames]

I'm using an IF formula that says =IF(B1="ABC", "DEF", <Do nothing>), but I don't know how to define the Do Nothing. If I put in double quotes it blanks the cell, which I don't want. Do the esteemed panel have any suggestions?

You can't 'do nothing' because by definition you have your IF statement in the cell. All you can do is change what the IF produces. What's wrong with a blank? What do you want it to be instead?

[Badger]

What do you want the 'do nothing' part of the clause to do? Putting double quotes in the 'do nothing' part does exactly that. You could always use "N/A"

[DiscoStu]

I'm using an IF formula that says =IF(B1="ABC", "DEF", <Do nothing>), but I don't know how to define the Do Nothing. If I put in double quotes it blanks the cell, which I don't want. Do the esteemed panel have any suggestions?