Forum Discussion

steele86's avatar
steele86
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's avatar
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's avatar
    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's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Oct 16, 2020

      Oldrockz Try this:

      =IF(SUM(B9:F9)=0,"",SUM(B9:F9))

       

      • OVO22's avatar
        OVO22
        Copper Contributor
        Oct 29, 2022
        Thank u

Resources