Posted to microsoft.public.excel.programming

sicelo matambo sicelo matambo is offline

external usenet poster

Posts: 2

adding if then statement in the formula below

=SUMPRODUCT(--(production!C5:C370=Week_no),((production!DP5:DP37 0))/(SUMPRODUCT(--(production!C5:C370=Week_no),((production!DS5:DS37 0)+(production!DV5:DV370))*settings!F27)))
with reference to the above formula,THE LAST PART '(production!DV5:DV370)' l want to add the following state if DV is nothing then it is equal to 13:50( the value in a specific cell DV162).
Thank you for your help

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
Adding another if statement to an index formula	Icehockey44	Excel Worksheet Functions	0	January 23rd 13 12:08 PM
Need help adding If/Then/Else Statement	imelda1ab	Excel Programming	3	March 13th 08 09:00 PM
Adding a WHERE statement	NEWER USER	Excel Programming	2	January 25th 08 06:38 PM
Adding a 3rd IF statement ??	yh73090[_5_]	Excel Programming	3	October 17th 04 05:57 PM
Adding a 3rd IF statement ??	yh73090[_6_]	Excel Programming	0	October 17th 04 04:50 AM

All times are GMT +1. The time now is 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us