Product + Sum (if)

Stylus88

New Member
Joined
Oct 31, 2019
Messages
5
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!


 

Forum statistics

Threads
1,077,795
Messages
5,336,373
Members
399,077
Latest member
johnk94

Some videos you may like

This Week's Hot Topics

Top