close

Hi,

I'm not very good with math...

I'm trying to achieve a cell that divides a cell number by 2 and then shows
20% ‘of’ the original.

e.g. this - 564.29 – to this - 225.72

I can do it in 2 cells using lots of brackets but can’t figure the calc out
in one cell.

ThanksHi,

You can use something like this if you have 546.29 in A1

=(A1-(A1*0.2))/2

Regards,
Bondi
Code:
--------------------

=a21/2-((a1/2)*0.2)
----------------------
bgeier
------------------------------------------------------------------------
bgeier's Profile: www.excelforum.com/member.php...oamp;userid=12822
View this thread: www.excelforum.com/showthread...hreadid=544202

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄