Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Tuesday, 31 May 2011

excel... if function... with add comparison... how possible could it be??? [research!]


situation

how idiot excel could be??? TOO MUCH… so many years are passed and Microsoft is sleeping! They haven't implement yet a parser to the world's famous application for calculations… excel “shame on you microsoft!!!”
problem

What is the fucken syntax for ADD comparison in IF function of excel
difficulty level

0/10 :| microsoft SUCKS
Compatibility

All f*cken excel versions
solution


The follow formula
=IF(AND(1=1;2=2);"this is true";"this is false")
returns “this is true”

the follow formula
=IF(AND(1=1;2=3);"this is true";"this is false")
returns “this is false”

with similar way use the OR comparison

good luck and don’t forget that microsoft sucks
Attention

microsoft sucks