If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ROUNDDOWN
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! |
#3
|
|||
|
|||
ROUNDDOWN
Dan,
This is a soutio that I tried and it worked: "=ROUNDDOWN(ROUNDDOWN(190-D1,0)*0.75,0)" and I got 31. hth "Dan Hoffman" wrote: 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! |
#4
|
|||
|
|||
ROUNDDOWN
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? "Dan Hoffman" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|