Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Formula Assistance ( | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
I need assistance with wrting an Excel formula | Excel Worksheet Functions |