formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
thank you!

Bob Phillips said:
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)
Click to expand...
 
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.
 
Back
Top