Hello all,

Been trying like crazy to get a formula to work. I have an invoice I
created. For this particular business, a 50% deposit is required. Two
fields below will show each half of the total. No problem, I thought -
until...

If the total is an odd amount, each cell shows the same amount no
matter what I tried. I think it is something to do with the rounding
or formatting, but can't seem to get that to work for some reason. Am
I an idiot? I can answer that for you. Yes.

So, what I am trying to do is, if the total amount is odd, I'd like
the DEPOSIT cell to be the extra penny and the BALANCE cell to be the
lower amount.

I have most of my hair left after pulling it out trying to figure this
out. Can anyone help before I need to buy some Rogaine?

Thanks to all in advance.

Mike


--
SpielbergRules
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557675

If your amount is in A1 then for deposit cell (let's assume A2) use

=FLOOR(A1/2,0.01)

then for balance cell

=A1-A2

format all cells fro currency


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557675

Thanks for that unbelievably fast reply! I will try it right now.

Mike


--
SpielbergRules
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557675