View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ConfusedNHouston ConfusedNHouston is offline
external usenet poster
 
Posts: 41
Default 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?