# 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.

Thread display: Collapse - | Expand +

## Related Discussions

• 0

#### Cold boot and soft restart problems

TechDefeated ·

• 0

SkyL0819 ·

• 1

#### screen mirroring

craigkaplan005 ·

• 0

#### Is my new pc's benchmark results normal?

efebilginer33 ·

• 0

Miltosss ·