Question
-
Topic
-
Get rid of the word”FALSE” in formula result
LockedThe thread I just looked at is 13 years old and closed, so I’m starting a new one. I have searched for two days to find a solution for this FALSE word appearing where a number result or blank should be.
My formula is working fine when the value of F8 is greater than 2 or 3. When the value is 1 or less, I get FALSE in that cell and other cells in the column (with basically the same formula).
=IF(AND($F$8<1),0,IF(AND($F$8>=2,$F$8<3),ROUND($F$6*1,0),IF(AND($F$8>=2,$F$8<3),ROUND($F$6*0.65,0),IF(AND($F$8>=3,$F$8<4),ROUND($F$6*0.45,0),IF(AND($F$8>=4,$F$8<5),ROUND($F$6*0.38,0),IF(AND($F$8>=5,$F$8<6),ROUND($F$6*0.33,0),IF(AND($F$8>=6,$F$8<7),ROUND($F$6*0.3,0))))))))
Any help would be greatly appreciated.
Mae
All Answers
Share your knowledge
Answer This