LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
Posts: 2
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"