Formula Assistance
 

Ok€¦heres 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

Formula Assistance
 

Try...

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

Hope this helps!

In article ,
Randy wrote:

Ok€¦heres 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.

Formula 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)-- the range syntax is C8:D8, 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((D8:D8)*24),SUM((F8:E8)*24,(D8:C8)*24) )


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=530162

Formula Assistance
 

No...unfortunately that did not work either...
--
Randy Street
Rancho Cucamonga, CA


"Domenic" wrote:

Try...

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

Hope this helps!

In article ,
Randy wrote:

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.

Formula Assistance
 

I do need it to subtract...
--
Randy Street
Rancho Cucamonga, CA


"jordun" wrote:


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)-- the range syntax is C8:D8, 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((D8:D8)*24),SUM((F8:E8)*24,(D8:C8)*24) )


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=530162

Formula Assistance
 

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))


"Randy" wrote:

Ok€¦heres 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

Formula Assistance
 

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

Thanks much for your assistance! Have a great day!
--
Randy Street
Rancho Cucamonga, CA


"Domenic" wrote:

Try...

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

Hope this helps!

In article ,
Randy wrote:

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.