Using ROUNDUP and IF within a cell, with a calculation already in it.

[CHarkin]

Hi all,

Hoping this one is a testing problem for the maestros on here.

I have a G8, which contains the following formula =VLOOKUP($C$2,Variables!G24:H43,2,FALSE)*$G$4

This returns a result of 0.4. What I want to is within the same formula in G8, add something that checks that if the value is less than 1, it rounds up the answer of that caluclation above to 1. It doesn't need to anything else, it just needs to round up to 1, if the value in the cell is calculated as lower than 1.

Can anyone assist please?

Many thanks

Ciarán

 

[Joe4]

Welcome to the Board!

Just wrap your whole formula in a MAX function, i.e.

=MAX(VLOOKUP($C$2,Variables!G24:H43,2,FALSE)*$G$4,1)

 

[CHarkin]

Welcome to the Board!

Just wrap your whole formula in a MAX function, i.e.

=MAX(VLOOKUP($C$2,Variables!G24:H43,2,FALSE)*$G$4,1)

Well you made light work of that Joe4. That's awesome, thank you very much.

 

[Joe4]

You are welcome!

I hope it makes sense. Feel free to ask any questions about it, if anything is unclear.

 

[CHarkin]

You are welcome!

I hope it makes sense. Feel free to ask any questions about it, if anything is unclear.

Much appreciated