Round Down

Q

Quilp

I have this formula in cell X73: =IF(A73="","",U73-(C73*2.433)) whic
returns the value 39.58.
In cell Y73 I have this formula: =ROUNDDOWN(X73,0) which returns th
value 39.
Is there any way that I can combine these formula's into cell X73 s
that I do not have to have column Y?
I have tried inserting + between the two and also tried AND but neithe
works. I am actually using Planmaker for this spread sheet but it i
almost the same as Excel, or so I am told.
I should mention that I am a 79 year old spread sheet newbie so pleas
be gentle with me
 
C

Claus Busch

Hi,

Am Fri, 16 Aug 2013 09:14:34 +0100 schrieb Quilp:
I have this formula in cell X73: =IF(A73="","",U73-(C73*2.433)) which
returns the value 39.58.
In cell Y73 I have this formula: =ROUNDDOWN(X73,0) which returns the
value 39.

try:
=IF(A73="","",ROUNDDOWN(U73-C73*2.433,0))
or
=IF(A73="","",INT(U73-C73*2.433))


Regards
Claus B.
 
Q

Quilp

Claus said:
Hi,

Am Fri, 16 Aug 2013 09:14:34 +0100 schrieb Quilp:
-

try:
=IF(A73="","",ROUNDDOWN(U73-C73*2.433,0))
or
=IF(A73="","",INT(U73-C73*2.433))


Regards
Claus B.

Fantastic! Your first suggestion has done it. Thanks a lot, Claus
 

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

Top