Question

Get rid of the word"FALSE" in formula result

By maecp ·
Tags: Microsoft
The 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
0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Desktop Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums