cannot find what is wrong with this forumula

[samsebastian]

If I plug in values for this formula is does not compute correctly. Somehow I made a mistake.. Can you find it? thx

=IF(OR(H1>=8.6,H1<=23),IF(OR(I1<=23,I1>=8),IF(AND(F1>=2,G1>=3,J1>=4),0.125,0),0),0)

[TMS]

Can you find it?

Probably not. You'd need to explain what you expected to see, and why, as opposed to what you do get. I don't think anyone is going to randomly test values without knowing what they're looking for. Do the cells have values in them or formulae depending on other cells?


Regards, TMS

[samsebastian]

I expected to see the value .125 if H1 is between 8.6 and 23 and if I1 is between 8 and 23 and if F1, G1 and J1 are all equal to or> 4.

[TMS]

Please Login or Register  to view this content.

Any and every number will meet this condition. For example, 7 is not greater than 8.6, but it is less than 23; 25 is not less than 23 but it is greater than 8.6.

Same with

Please Login or Register  to view this content.

Perhaps you need to change your ORs to ANDs if you are trying to restrict a value between a range of values.

Regards, TMS