0
   

Excel formula

Forums: Excel, Excel Formula
Email this Topic • Print this Page
 
 
InfraBlue
 
Reply Wed 11 May, 2016 02:06 pm
In Microsoft Excel, what would be the formula for subtracting 20% from an amount and then subtracting an additional 25,000.

For example, 135,267 -20%=108,213.6-25,000=83,213.6.

135,267 is in cell B2.
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,172 • Replies: 2

 
timur
 
  3  
Reply Wed 11 May, 2016 02:14 pm
A2=B2*0.8-25000

Write your initial figure in B2 and the formula in A2.

InfraBlue
 
  1  
Reply Wed 11 May, 2016 02:25 pm
@timur,
Ah! Thank you very much, timur.
0 Replies
 
 

Related Topics

How to repair xls file corrupted - Question by robert79
Excel Problem - Question by DaughterRuler
Find and move the duplicate values in another sheet - Question by maximbebi
Change default fill color - Question by Sigandi
Positive/negative calculation in exel - Question by peterhuijts
i need to know about the excel function of converting binary to decimal with online video tutorial - Question by pranesh
IS there any calc aavilable in Excel worksheets regarding home budget and savings? - Question by pranesh
Extracting info from one column based on criteria in another - Question by artdba
solving an exponential growth equation using excel - Question by duramax
How to Get Rid of the Excel Ribbon - Discussion by engineer
Paging Excel Gurus: Agita with Column Widths... - Question by Region Philbis
 
  1. Forums
  2. » Excel formula
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 04/25/2024 at 12:10:23
▲ ▼