Calculation Add Up

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,



I'm trying to get the formula for the above calculation however I cant figure it out.

I'm trying to add 20% only when the total amount is less than 100.

Appreciate if you could help me with the formulation.

Thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
if the value (<100 or >=100)) is in A1, then in an empty cell type this formula

=IF(A1<100,A1*120%,"")