Forum Discussion
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?
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?
- I think I used wrong choice of words. The formula you provided worked. Thank you so much!!
