Posted to microsoft.public.excel.worksheet.functions

OwenGiryluk OwenGiryluk is offline

external usenet poster

Posts: 2

Challenge

=IF(BG229=0,IF(BE229=3,AK229*(0+Input!$G$10),IF(BE 229=4,AK229*(0+Input!$G$11),
IF(BE229=5,AK229*(0+Input!$G$13),IF(BE229=6,AK229* (0+Input!$G$14),IF(BE229=7,
AK229*(0+Input!$G$15),0))))))

This formula returns a "FALSE" statement if not true. Anyway to change the
formula to return a zero if FALSE. THANKS...

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
Shortcut Key --- A Challenge	Deepak	Excel Discussion (Misc queries)	1	December 9th 06 02:02 AM
A Challenge	jimbob	Excel Discussion (Misc queries)	17	April 1st 06 10:37 PM
Algorithm Challenge	Lowkey	Excel Worksheet Functions	4	July 20th 05 06:40 PM
A Challenge	Jazzer	Excel Worksheet Functions	3	July 8th 05 05:08 PM
Who is up for a challenge?	Jambruins	Excel Discussion (Misc queries)	2	April 12th 05 08:23 PM

All times are GMT +1. The time now is 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us