SUGGESTION - IF command option

L

Lin Kypta

To Excel Designers:
Please consider adding a "do nothing" option to the IF command as follows:
IF(Month_Number=1,Income_197,*) THIS IS ONLY AN EXAMPLE"
Where
"Month_Number" is a symbolic adr
"Income_197" is a symbolic adr
The astereik (or any symbol that will be unique in this application) is a
special symbol that selects "no action taken" or "no data transferred".
The above is meant to represent the suggested change ONLY and the use of the
IF command is absolutely ordinary, except for the suggested change.

I have rather urgent need for this option and will be glad to elaborate
further.
Lin
 
F

FSt1

hi
i'm having trouble understanding your concept.
the if formula has built in this "take no actions" your speak of.
=if(condition, action if true, action if false)
or
=if conditon, action if true, "")
the "" mean leave a blank cell or no action taken.
if this is not what you ment to convey, then post more details.

regards
FSt1
 
Top