0
   

Excel formula

 
 
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,018 • 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

 
  1. Forums
  2. » Excel formula
Copyright © 2022 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 07/01/2022 at 05:39:32