ExcelBanter - Nested IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Nested IF Function (https://www.excelbanter.com/excel-discussion-misc-queries/120628-nested-if-function.html)

ConfusedNHouston

Nested IF Function

I've done nested if's before but I'm running into some strangness:

Here's what I'm entering in the formula line:

=IF($F$28=100,IF(E130,IF(F130,I13,"")))

It's working, but rather than entering "0" for the false condition it's
writing FALSE in the cell - it just looks ugly. How do I stop it from doing
that?

All times are GMT +1. The time now is 09:50 PM.