Web Hosting Talk







View Full Version : Help with reading an excel formula


ThatScriptGuy
08-27-2006, 07:08 PM
I've googled and googled and googled to no avail..
I'm converting an excel file to a PHP/JS solution, and I'm having trouble figuring out what one of the excel formulas is saying (it's actually one of the last formulas left and of course it's the one that throws me problems)

The expression is:
=IF('Treatment Program'!L20<>0,50 / 'Treatment Program'!L20,0)

If someone can tell me in english what that is saying, I'd be very appreciative (or tell me what the exclamation marks mean..or <> or anything about it...)
Thanks,
Kevin

ThatScriptGuy
08-27-2006, 07:14 PM
OK, after looking at it again, I've sort of figured it out....

If (previous screen, cell L20) is <> 0 (dunno what <> means still), then perform 50/ (previous screen, cell L20), else, cell equals 0...

If I just know what <> is then I can finish this up..Anybody?

EDIT: Is <> 'not equal to'?

ThatScriptGuy
08-27-2006, 09:46 PM
OK, so <> is not equal to...got it :)

osteoarthitis
08-30-2006, 04:53 PM
these are called the comparisin operators and they are <,>,+,+=,!= and <> ,
!= and <> are equal

ThatScriptGuy
08-30-2006, 04:54 PM
Yup, figured it out awhile ago..
Thanks..