software

Ok…here’s the scenario:
I have a formula…

=IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))

I need this formula to add the totals of two cells (D8-C8) if a particular
cell on another sheet is blank. If the cell on the other sheet is not blank I
need it to sum the same two cells (D8-C8) in addition ( ) to the sum of two
additional cells (F8-E8).

Can anyone see anything wrong with what I have so far? Any ideas or
suggestions would be most helpful.

Thank you for your time and look forward to any assistance.

--
Randy Street
Rancho Cucamonga, CA

Try...

=IF(ISBLANK('Check-In'!F4),(D8-C8)*24,((F8-E8)*24) ((D8-C8)*24))

Hope this helps!

In article gt;,
Randy gt; wrote:

gt; Ok…here’s the scenario:
gt; I have a formula…
gt;
gt; =IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))
gt;
gt; I need this formula to add the totals of two cells (D8-C8) if a particular
gt; cell on another sheet is blank. If the cell on the other sheet is not blank I
gt; need it to sum the same two cells (D8-C8) in addition ( ) to the sum of two
gt; additional cells (F8-E8).
gt;
gt; Can anyone see anything wrong with what I have so far? Any ideas or
gt; suggestions would be most helpful.
gt;
gt; Thank you for your time and look forward to any assistance.


Hi
he p[roblem seems to be the sybtax of the ranges in the SUM functions

=IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))

1 - SUM((D8-C8)*24)--gt; the range syntax is C88, when you write D8-C8
you are telling Excel D8 minus C8

2 - The same for SUM((F8-E8)I guess your formula should look like this:
=IF(ISBLANK('Check-In'!F4),SUM((D88)*24),SUM((F8:E8)*24,(D8:C8)*24) )--
jordun------------------------------------------------------------------------
jordun's Profile: www.excelforum.com/member.php...oamp;userid=33118
View this thread: www.excelforum.com/showthread...hreadid=530162No...unfortunately that did not work either...
--
Randy Street
Rancho Cucamonga, CAquot;Domenicquot; wrote:

gt; Try...
gt;
gt; =IF(ISBLANK('Check-In'!F4),(D8-C8)*24,((F8-E8)*24) ((D8-C8)*24))
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Randy gt; wrote:
gt;
gt; gt; Ok…here’s the scenario:
gt; gt; I have a formula…
gt; gt;
gt; gt; =IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))
gt; gt;
gt; gt; I need this formula to add the totals of two cells (D8-C8) if a particular
gt; gt; cell on another sheet is blank. If the cell on the other sheet is not blank I
gt; gt; need it to sum the same two cells (D8-C8) in addition ( ) to the sum of two
gt; gt; additional cells (F8-E8).
gt; gt;
gt; gt; Can anyone see anything wrong with what I have so far? Any ideas or
gt; gt; suggestions would be most helpful.
gt; gt;
gt; gt; Thank you for your time and look forward to any assistance.
gt;

I do need it to subtract...
--
Randy Street
Rancho Cucamonga, CAquot;jordunquot; wrote:

gt;
gt; Hi
gt; he p[roblem seems to be the sybtax of the ranges in the SUM functions
gt;
gt; =IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))
gt;
gt; 1 - SUM((D8-C8)*24)--gt; the range syntax is C88, when you write D8-C8
gt; you are telling Excel D8 minus C8
gt;
gt; 2 - The same for SUM((F8-E8)
gt;
gt;
gt; I guess your formula should look like this:
gt; =IF(ISBLANK('Check-In'!F4),SUM((D88)*24),SUM((F8:E8)*24,(D8:C8)*24) )
gt;
gt;
gt; --
gt; jordun
gt;
gt;
gt; ------------------------------------------------------------------------
gt; jordun's Profile: www.excelforum.com/member.php...oamp;userid=33118
gt; View this thread: www.excelforum.com/showthread...hreadid=530162
gt;
gt;

1) You don't offer a hint of what issue you are experiencing
2) You don't need the SUM() function
3) Since you are ALWAYS adding 24*(D8-C8), the formula could be shorter:

=24*((D8-C8) IF(ISBLANK('Check-In'!F4),(F8-E8),0))quot;Randyquot; wrote:

gt; Ok…here’s the scenario:
gt; I have a formula…
gt;
gt; =IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))
gt;
gt; I need this formula to add the totals of two cells (D8-C8) if a particular
gt; cell on another sheet is blank. If the cell on the other sheet is not blank I
gt; need it to sum the same two cells (D8-C8) in addition ( ) to the sum of two
gt; additional cells (F8-E8).
gt;
gt; Can anyone see anything wrong with what I have so far? Any ideas or
gt; suggestions would be most helpful.
gt;
gt; Thank you for your time and look forward to any assistance.
gt;
gt; --
gt; Randy Street
gt; Rancho Cucamonga, CA

Got it....This is what I came up with...
=IF('Check-In'!F4=quot;quot;,(D8-C8)*24,((F8-E8)*24) ((D8-C8)*24))

Thanks much for your assistance! Have a great day!
--
Randy Street
Rancho Cucamonga, CAquot;Domenicquot; wrote:

gt; Try...
gt;
gt; =IF(ISBLANK('Check-In'!F4),(D8-C8)*24,((F8-E8)*24) ((D8-C8)*24))
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; Randy gt; wrote:
gt;
gt; gt; Ok…here’s the scenario:
gt; gt; I have a formula…
gt; gt;
gt; gt; =IF(ISBLANK('Check-In'!F4),SUM((D8-C8)*24),SUM((F8-E8)*24,(D8-C8)*24))
gt; gt;
gt; gt; I need this formula to add the totals of two cells (D8-C8) if a particular
gt; gt; cell on another sheet is blank. If the cell on the other sheet is not blank I
gt; gt; need it to sum the same two cells (D8-C8) in addition ( ) to the sum of two
gt; gt; additional cells (F8-E8).
gt; gt;
gt; gt; Can anyone see anything wrong with what I have so far? Any ideas or
gt; gt; suggestions would be most helpful.
gt; gt;
gt; gt; Thank you for your time and look forward to any assistance.
gt;