Help with simple formula

S

SS

In cell k27 £309
In cell J28 20% (this % can vary)
In cell K28 I want £309-20%, which should be around £247.20
I am getting £308.80

Using this formula K27-J28, I know its wrong but can`t work it out.

Would someone please correct for me.
thanks
 
G

Gord Dibben

You cannot subtract a percentage in that manner.

=K27-(K27*J28) entered in K28 formatted as number with 2 DP

Returns 247.20


Gord Dibben MS Excel MVP
 
S

SS

Many thanks, now sorted.


Gord Dibben said:
You cannot subtract a percentage in that manner.

=K27-(K27*J28) entered in K28 formatted as number with 2 DP

Returns 247.20


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 2
Change Range In COUNTIF Formula Based On Value In A Cell 1
How to use union reference operator? 4
My formula gives a wrong total...help! 3
if function? 2
Copy addition formula of non-consecutive horizontal cells 2
Help with time please. 1
Formula Referencing Columns By Date 2

Top