Forum Discussion

Copper Contributor

Sep 13, 2020

If and Sum Nested formula

This is what I have =if(b9:F9=0,"",B9:F9). Obviously it's not working lol. I'm having trouble with the false. According to my assignment, it's supposed to display the sum if it is false. here is ...

excel

HansVogelaar

MVP

Sep 13, 2020

steele86

You haven't used the SUM function in your formula. The assignment says to check the total of B9:F9, so where should you use SUM?

Oldrockz

Copper Contributor

Oct 16, 2020

HansVogelaar the question wants us to create a nested formula containing IF and SUM, so we are asking if how to create a nested formula containing SUM and IF functions, or if we could use SUMIF. we need the function to check and see if the sum of hours worked during 1 week is

=0 if yes then we need it to display nothing, otherwise we need the cell to display hours of time worked

Riny_van_Eekelen
Platinum Contributor
Oct 16, 2020
Oldrockz Try this:
=IF(SUM(B9:F9)=0,"",SUM(B9:F9))
- OVO22
  Copper Contributor
  Oct 29, 2022
  Thank u
- DEOL48
  Copper Contributor
  Jun 05, 2022
  I have a above formula in column but I need a Sum of this column ang SUM formula is showing 00:00
  Riny_van_Eekelen
  - HansVogelaar
    MVP
    Jun 05, 2022
    DEOL48
    
    The values in column F are left-aligned. That suggests they might be text values.
    
    Try the following:
    
    Select column F.
    
    Set the number format to a time format,
    
    On the Data tab of the ribbon, click Text to Columns.
    
    Click Finish.
    
    Does that make a difference?
- JBailey992
  Copper Contributor
  Mar 19, 2022
  Thank you! I also am working on this assignment for Excel and could not figure out this formula either. I greatly appreciate your help!