Excel QUESTION

[billybernadette]

I have this excel formula and i dont know if there is an error or not. if someone could explain this if its not an error that would be great.

IF(1>=1, IF(2<>1,1,3,),2)+1

 

[StephenCrump]

IF(1>=1, IF(2<>1,1,3,),2)+1

Someone else's formula? Looks to me like they're just messing around testing how IF() functions work.

There is an error in the formula, as there are too many parameters provided for the middle IF().

Assuming it's meant to be: IF(1>=1, IF(2<>1,1,3),2)+1

then the formula will always return 2, i.e. it's not a sensible formula that has any real use.

 

[FDibbins]

What is this supposed to be doing?

The 1st IF is redundant as 1>=1 will always return TRUE (1 is always = 1)
the 2nd IF has an extra , in there at the end
IF(1>=1, IF(2<>1,1,3,),2)+1
it is also pretty much redundant, as 2will always be <>1 so that will also always be TRUE

IF(1>=1, IF(2<>1,1,3,),2)+1 will always return 2 (as was said above)
IF(1>=1 means that this will always be the next part that triggers IF(2<>1,1,3)
so this will always return 1...plus he +1 at the end, outside all the IF's, gives 2