View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Randy
 
Posts: n/a
Default 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