Hi guys i have an excel function lesser than equal to and it doesn't work right in some places. This is my formula.
IF(AND(C33>=A113;C33<=A117;C35>=A113;C35<=A117); ((MAIN!C15*8) +8+5)*10;"NO AREA MATCH")
In some cells it works and gives me the right value but in others the part in italics does not work.
For eg: if C33= 240 ; C35 = 300; A113=10; A117=50
The formula still gives me true thought he answer is No area match. Can you guys tell me why? I tries running "evalute formula and the part C33<=A117 is True when it is actually false. Can you tell me why this is happening and how I can correct it
Regards
Sneha
Bookmarks