Monday, March 07, 2011 8:48:09 AM
Excel formula
Ken:
In Excel the phrase <> is equivalent to 'Not Equal To" Or "NE" in some languages.
In the context of =IF(B29<>"",J29*D29/100,"") Clive is correct, its use is to determine if the contents of B29 are empty (which is what the "" phrase means).
So if B29 is not empty, do the calculation, otherwise keep it empty.
Boolean if, then, else if I ever saw one.
Not to stir up the pot, but I'm always amazed why people continue to calculate %'s this way. Excel has always had the ability to format a 0.xx value as xx%. The value of 15% is 0.15.
Ken:
In Excel the phrase <> is equivalent to 'Not Equal To" Or "NE" in some languages.
In the context of =IF(B29<>"",J29*D29/100,"") Clive is correct, its use is to determine if the contents of B29 are empty (which is what the "" phrase means).
So if B29 is not empty, do the calculation, otherwise keep it empty.
Boolean if, then, else if I ever saw one.
Not to stir up the pot, but I'm always amazed why people continue to calculate %'s this way. Excel has always had the ability to format a 0.xx value as xx%. The value of 15% is 0.15.
Best Regards, Steve (The Grabber)
Join the InvestorsHub Community
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.
