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
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
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
Related:
- Calculation Add Up
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- Calculation is incomplete. recalculate before saving - Guide
- How to add @ in laptop - Guide
- How to add songs to sound picker - Guide
- Debian add printer - Guide
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
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%,"")
=IF(A1<100,A1*120%,"")