What does "" mean in an equation

D

Dustin Kuers

I am trying to explain this equation but I don't understand what the "
is used for.
=IF(B3<"",(C3-B3)/31,"")
Thanks for the help.
Dusti
 
G

GS

I am trying to explain this equation but I don't understand what the
"" is used for.
=IF(B3<"",(C3-B3)/31,"")
Thanks for the help.
Dustin
Click to expand...

"" is an empty string! Though I suspect a typo in the formula example
because it states...

If B3 is less than empty *then* subtract B3 from C3 and divide the
result by 31, *else* return an empty string

...but I don't get the *less than empty* part. I think the formula
should be...

=IF(B3<>"",(C3-B3)/31,"")

...which states if B3 is not empty then do the math!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
Finding asymptote equation and how to draw them in excel 0
summarizing data from various workbooks 4
Need to have data in one column 1
% Achieved 2
Excel equations 6
Different Word 2016 equation editors 0
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top