# Desktop

## Question

Locked

### Get rid of the word"FALSE" in formula result

By ·
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)
Thread display: Collapse - | Expand +

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

## Related Discussions

• 2

Punnyman ·

• 0

oragex ·

• 0

#### Best way for per second BW monitoring?

nikallavdepahilefu ·

• 2

paulmars ·

• 1

paulmars ·