ROUNDDOWN

D

Dan Hoffman

I'm trying to get two numbers to ROUNDDOWN.
I can get the 1st number to ROUNDDOWN but I can't
get the second number to ROUNDDOWN.

I want to enter 3119 into cell B1 and enter 21 into cell C1

I want the number in cell D1 to ROUNDDOWN to 148, so
I've entered =ROUNDDOWN(B1/C1,0) and I get 148.5
Rounded Down to 148.

Now I need cell A1 to do as follows:

190 is my base, so I need 190 - D1 (which was 148) to equal 42
then I need 75% of 42 Rouned Down to 31 not 31.5. I got this
by entering the following: =ROUNDDOWN(190-D1,0)*0.75

Any help would be wonderful!
 
J

Joe User

Dan Hoffman said:
190 is my base, so I need 190 - D1 (which was 148) to equal 42
then I need 75% of 42 Rouned Down to 31 not 31.5. I got this
by entering the following: =ROUNDDOWN(190-D1,0)*0.75

=ROUNDDOWN((190-D1)*75%,0)


----- original message -----
 
F

FloMM2

Dan,
This is a soutio that I tried and it worked:
"=ROUNDDOWN(ROUNDDOWN(190-D1,0)*0.75,0)"
and I got 31.
hth
 
T

teylyn

Hi,

since you want to round down the result of the calculation

(190-D1)*0.75

you have to put the whole formula inside the rounddown function, like this

=ROUNDDOWN((190-D1)*0.75,0)

Does that help?
 

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