Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-15-2017, 07:20 AM
yoyo4 yoyo4 is offline percentage calculation formula Windows 10 percentage calculation formula Office 2013
Novice
percentage calculation formula
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default percentage calculation formula

Hi

how to put percentage calculation formula following example.
According to the net profit need to change percentage amount.



EX-
Net Profit - 20000(cell-A1)

high in 20000 then 20% net
Net profit between in 10000 and 20000then 15% net
Net profit less 10000 then 10% net

Above percentages value in net profit need fill automatically (Ce11-B2)
Net profit -16000
15% net-15/100=2400(this amount need fill automatically(Ce11-B2)
Reply With Quote
 

Tags
excel 2013, excel formula



Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the formula for getting the percentage for time phoenix666! Excel 1 07-29-2016 08:18 AM
percentage calculation formula Calculation of Percentage Completion of Summary Tasks raminraiszadeh Project 2 04-06-2015 06:38 AM
Formula Calculation medavidcook Excel 2 03-21-2015 03:47 AM
percentage calculation formula Formula calculation danbl Excel 8 02-23-2012 04:35 AM
percentage calculation formula Excel 2010 formula rounds - arithmetic average calculation YooNaa Kim Excel 1 06-07-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft