ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What does "" mean in an equation (https://www.excelbanter.com/excel-discussion-misc-queries/449287-what-does-mean-equation.html)

Dustin Kuers

What does "" mean in an equation
 
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

GS[_2_]

What does "" mean in an equation
 
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


"" 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




All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com