formula

[las]

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

 

[Bob Phillips]

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]

thank you!

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)

 

[Hanr3]

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.