formula
 

I got this response (which worked)for a question I had on a formula and not
to sound silly but what does the double quotation mark mean in this formula?

=IF(D22="Yes",IF(B10*0.05<D10,B10*0.05,D10),IF(D22 ="No",0,""))

thanks
las

formula
 

It is a default action, if no other condition is met, it returns an empty
string.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"las" wrote in message
...
I got this response (which worked)for a question I had on a formula and
not
to sound silly but what does the double quotation mark mean in this
formula?

=IF(D22="Yes",IF(B10*0.05<D10,B10*0.05,D10),IF(D22 ="No",0,""))

thanks
las

formula
 

thank you!

"Bob Phillips" wrote:

It is a default action, if no other condition is met, it returns an empty
string.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"las" wrote in message
...
I got this response (which worked)for a question I had on a formula and
not
to sound silly but what does the double quotation mark mean in this
formula?

=IF(D22="Yes",IF(B10*0.05<D10,B10*0.05,D10),IF(D22 ="No",0,""))

thanks
las

formula
 

I would like to add that the " _ " marks around anything will display what is
between them as text. So having double quotaion marks next to each other will
display nothing. Sometimes having an empty cell is confusing or leads you to
question is the formula is working, or if the data is correct. I prefer to
put something in there as verification there are no errors. My favorite to
use is "-" or "n/a". It will display as - or n/a.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"las" wrote:

thank you!

"Bob Phillips" wrote:

It is a default action, if no other condition is met, it returns an empty
string.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"las" wrote in message
...
I got this response (which worked)for a question I had on a formula and
not
to sound silly but what does the double quotation mark mean in this
formula?

=IF(D22="Yes",IF(B10*0.05<D10,B10*0.05,D10),IF(D22 ="No",0,""))

thanks
las