IF & ROUND UP FORMULA SUPPORT

[Ash Hayashi]

Hello,
Not sure if it is doable or not. But was hoping there is a way to get this to work.

I am looking to combine an IF & ROUND UP statement into one cell (K5). This cell is already looking at data from multiple other cells to give me a value.
But, if that value is equal to the same value in the cell beside it (L5), I want it to round up by 1.

Current formula in K5 cell is: =(ROUNDUP((B7*G14)/B6,0)*Q5)

I was thinking something like this formula might help, but I can't quite get the two formulas to merge in a way that works: =IF(K5>=L5,K5+1, ROUNDUP(K5,0))

Hopefully this all makes sense. Thank you to anyone that can help.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(r,ROUNDUP((B7*G14)/B6,0)*Q5,IF(L5<r,r,r+1))

 

[Ash Hayashi]

Doesn't seem to work. . . .
What does the "r" represent?

 

[Fluff]

Doesn't seem to work. . . .

In what way?

 

[Ash Hayashi]

In what way?

It accepted the formula without error. However, it did not round anything. The value in K5 still matches the value in L5.

 

[Fluff]

In that case the value in L5 is less than the value in K5

 

[Ash Hayashi]

Oh, duh! lol

Thank you. That seems to have done the trick!

I'm not familiar with LET formulas at all. So, I've learned something. Thank you again!

 

[Fluff]

You're welcome & thanks for the feedback.