Posted to microsoft.public.excel.misc

ConfusedNHouston ConfusedNHouston is offline

external usenet poster

Posts: 41

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested Function	mrfrenchy	Excel Discussion (Misc queries)	8	November 16th 06 12:03 AM
Nested IF function	melissat	Excel Worksheet Functions	5	October 18th 06 11:40 AM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
Countif Function -Nested	Angi	Excel Discussion (Misc queries)	7	May 4th 05 07:04 PM

All times are GMT +1. The time now is 12:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us