Forum Discussion

rhonda kelley's avatar
rhonda kelley
Copper Contributor
Jun 11, 2018

Formula help

I have been trying for hours to figure this out with no resolve. In the cell I need the final number, I need to return either a zero value based on the number entered in one cell or the sum of a formula from another cell.

Cell M76. I need a formula that states if cell M74 is zero, then return the sum of =M73*17/390 in cell M76. If cell M74 has a value greater than zero (1-8), then return a value of zero in cell M76. Does such formula exists?
  • It looks like

    =IF(M74=0,M73*17/390,0)

    for M76, assuming M74 is never negative. And what do you mean under the sum, with what?

     

    • rhonda kelley's avatar
      rhonda kelley
      Copper Contributor
      I think I used wrong choice of words. The formula you provided worked. Thank you so much!!