IF and ROUNDUP / ROUNDDOWN

[HEORIST]

Hi,

I am trying to compare 2 values: D39 and F39. The second IF gives me a FALSE result. Why is it so? I tried also stating it as D39>F39 and D39< F39 but still got the same result.

=IF(D39-F39>1;ROUNDDOWN(D39/F39;IF(D39-F39<1;ROUNDUP(D39/F39;0))))

Thank you for any help.

 

[Repush]

it helps if you tell us what's in D39 and F39
logic suggests that D39-F39=1

 

[Fluff]

If it's not less than & or greater than 1 then it must be 1.
What are D39 & F39?

 

[HEORIST]

Hi,
Thanks for the quick reply.

I am trying to figure out how many vials I need given the dose needed. So D39 gives the amount of drug needed and F39 gives the amount of drug contained in a vial.
For ex, D39 can be 1100 mg and F39 can be 1200 mg vial. So in this case, 1 vial of F39 is needed with a 100 mg wastage. The other condition is when D39 is 1200 or more, for ex, if D39 is 1200 mg, then only 1 unit of F39 is needed. If D39 is 1800 mg, then 2 F39 vials are needed, with a wastage of 600 mg.

 

[Fluff]

Your rounddown formula is wrong, try
=IF(D39-F39>1,ROUNDDOWN(D39/F39,0),IF(D39-F39<1,ROUNDUP(D39/F39,0)))

But you will still get false if D39-F39=1

 

[Kerryx]

Hi,

I am trying to compare 2 values: D39 and F39. The second IF gives me a FALSE result. Why is it so? I tried also stating it as D39>F39 and D39< F39 but still got the same result.

=IF(D39-F39>1;ROUNDDOWN(D39/F39;IF(D39-F39<1;ROUNDUP(D39/F39;0))))

Thank you for any help.

Will this work for you
=if(d39-F39)>=1,1,roundup(f39/d39,0))

 

[Kerryx]

Will this work for you
=if(d39-F39)>=1,1,roundup(f39/d39,0))

sorry meant to be
=IF(F39-D39>=1,1,ROUNDUP(D39/F39,0))

 

[HEORIST]

sorry meant to be
=IF(F39-D39>=1,1,ROUNDUP(D39/F39,0))

Dear Kerryx,

Thank you so much. I just changed the commas to semi-colons and the formula worked!

Now I can proceed. Have a great day.

 

[HEORIST]

Your rounddown formula is wrong, try
=IF(D39-F39>1,ROUNDDOWN(D39/F39,0),IF(D39-F39<1,ROUNDUP(D39/F39,0)))

But you will still get false if D39-F39=1

Dear Fluff,

Thanks for this! It also worked.

Kind regards and have a good day.

 

[Fluff]

You're welcome & thanks for the feedback