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)
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)
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?Can you find it?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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.
Formula:
OR(H1>=8.6,H1<=23)
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 withFormula:
OR(I1<=23,I1>=8)
Perhaps you need to change your ORs to ANDs if you are trying to restrict a value between a range of values.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks