Formula help, deducting 10%

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

I have =(K24+K25)-(10%)

So trying to do... £285+£285-10% the answer is giving me £569.90
should be £513

Also once I sort this I want to add on £50 to the £513 would that be +(50)
at the end of the formula.


thanks
 
SS said:
Subject: Formula help, deducting 10%
I have =(K24+K25)-(10%)
So trying to do... £285+£285-10%
[....] should be £513
Click to expand...


Try:

=(K24+K25)*(1-10%)

or

=(K24+K25)*90%


----- original message -----
 
Sorted thanks Joe


Joe User said:
SS said:
Subject: Formula help, deducting 10%
I have =(K24+K25)-(10%)
So trying to do... £285+£285-10%
[....] should be £513
Click to expand...


Try:

=(K24+K25)*(1-10%)

or

=(K24+K25)*90%


----- original message -----

SS said:
I have =(K24+K25)-(10%)

So trying to do... £285+£285-10% the answer is giving me £569.90
should be £513

Also once I sort this I want to add on £50 to the £513 would that be
+(50) at the end of the formula.


thanks
Click to expand...
Click to expand...
 
Back
Top