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