| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i get the if statement i nthis formula to work
=IF(((Sheet1!E6="x")*OR(Sheet1!F6="x")*OR(E6="x")* OR(F6="x")),"x",(IF((E6=Sheet1!E6)*AND(F6=Sheet1!F 6),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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| IF formula - evaluation shows it should work but... | Excel Worksheet Functions | |||
| Auto Extend Formulas doesn't work for a particular formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Threaded Mode
