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

Thread Tools
Display Modes


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 02:34 AM.


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