It is possible to have a formula where i can add a sum to a product? And in my particular case, is it possible that the result of the cell have the sum of a value just only if there are particular conditions?
MY case
=PRODUCT(S15,0.3)
I placed this formula in order to have the result of s15*0,3.
In this cell I want also to add a + 1 to the result IF the result of another cell (r15) is >40, and + 2 if r15>80.
Thank you!
MY case
=PRODUCT(S15,0.3)
I placed this formula in order to have the result of s15*0,3.
In this cell I want also to add a + 1 to the result IF the result of another cell (r15) is >40, and + 2 if r15>80.
Thank you!