- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- How do i get the if statement i nthis formula to work

Subject: | How do i get the if statement i nthis formula to work |

Posted by: | Mark |

Date: | Fri, 12 May 2006 |

=IF(((Sheet1!E6="x")*OR(Sheet1!F6="x")*OR(E6="x")*OR(F6="x")),"x",(IF((E6=Sheet1!E6)*AND(F6=Sheet1!F6),3,(IF((E6-F6)=(Sheet1!E6-Sheet1!F6),2,(IF((SIGN(E6-F6))=(SIGN(Sheet1!E6-Sheet1!F6)),1,0)))))))

I want it that if any of the 4 first statements = x that it returns a value

of x. All the fields in Sheet1!E^ and Sheet1!F^ are x. The problem i am

getting is that its returning a value of #VALUE. Not the x i am expecting.

It seems the or statement isnt working the way i expect.

- Re: How do i get the if statement i nthis formula to work posted by Bob Phillips on Fri, 12 May 2006