BEEJAY

Posts: n/a

IF Function returns False instead of 0

I must be going blind.

The first statement returns a "false" when not equal
Likewise the second.
The third returns a zero (0).
I need a Zero from each one (if applicable), instead of "false".
What am I overlooking.
I'm thought I've used this satisfactorily before, but I'm stuck now.

=IF(C6=E11,IF(C5=D11,IF(C3<=28,F11,0)))

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Grouped Sheets and Formating	Pank Mehta	Excel Discussion (Misc queries)	3	March 24th 05 01:42 AM
Grand Totals @ Same Place	Amber M	Excel Worksheet Functions	2	December 30th 04 07:13 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 11:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us