Calculation Add Up

Closed
Lynn - Dec 1, 2011 at 10:14 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 2, 2011 at 12:17 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 2, 2011 at 12:17 AM
if the value (<100 or >=100)) is in A1, then in an empty cell type this formula

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