1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • =?UTF-8?Q?Count_full_values_=28For_every_full_pound_=C2=A30=2E01=29?=

    From mralmackay@gmail.com@21:1/5 to All on Wed Feb 19 00:56:04 2020
    I'm sure I'm over-complicating thinking here but tried searching the forums as well and wasn't able to find similar.

    The ask is how to leverage a formula to put £0.01 in a cell for every full pound? In the example below Column B is where the formula would be placed

    So, e.g.

    A B
    £9 £0.09
    £9.30 £0.09
    £4 £4
    £0.50 £0

    Appreciate any help and apologies if I've completely missed the obvious easy way of doing this!

    Thanks, Al

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From mralmackay@gmail.com@21:1/5 to mralm...@gmail.com on Wed Feb 19 00:57:31 2020
    On Wednesday, 19 February 2020 08:56:07 UTC, mralm...@gmail.com wrote:
    I'm sure I'm over-complicating thinking here but tried searching the forums as well and wasn't able to find similar.

    The ask is how to leverage a formula to put £0.01 in a cell for every full pound? In the example below Column B is where the formula would be placed

    So, e.g.

    A B
    £9 £0.09
    £9.30 £0.09
    £4 £0.04
    £0.50 £0

    Appreciate any help and apologies if I've completely missed the obvious easy way of doing this!

    Thanks, Al

    Sorry, above should note £0.04 for the 3rd row.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Wed Feb 19 10:28:26 2020
    Hi,

    Am Wed, 19 Feb 2020 00:56:04 -0800 (PST) schrieb mralmackay@gmail.com:

    The ask is how to leverage a formula to put £0.01 in a cell for every full pound? In the example below Column B is where the formula would be placed

    So, e.g.

    A B
    £9 £0.09
    £9.30 £0.09
    £4 £4
    £0.50 £0

    try:
    =INT(A1)/100


    Regards
    Claus B.
    --
    Windows10
    Office 2016

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From mralmackay@gmail.com@21:1/5 to Claus Busch on Wed Feb 19 01:48:51 2020
    On Wednesday, 19 February 2020 09:28:30 UTC, Claus Busch wrote:
    Hi,

    Am Wed, 19 Feb 2020 00:56:04 -0800 (PST) schrieb:

    The ask is how to leverage a formula to put £0.01 in a cell for every full pound? In the example below Column B is where the formula would be placed

    So, e.g.

    A B
    £9 £0.09
    £9.30 £0.09
    £4 £4
    £0.50 £0

    try:
    =INT(A1)/100


    Regards
    Claus B.
    --
    Windows10
    Office 2016


    That's the one - great, thanks Claus!!

    Have a great day. Cheers, Al

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)