Need help adding multiple 'IF' statements to existing formula

[Ben Ash]

I am attempting to add to an existing formula within my workbook but can't work out the best way to do so.

My current formula is as follows

=IF(D28="",0,ROUNDUP(I22/250,0))

In addition to this I would like to add the following criteria:

IF 'COSTING SHEET'!A28= "bottom"&'INPUT SHEET'!B27= "Y" then add 50% to final sum.

Hope someone can help.

Thanks in advance guys.

[Jonmo1]

Do you want that 50% added to the I22/250 Before or After it's rounded ?

[Ben Ash]

After its rounded please.

[Jonmo1]

Try

=IF(D28="",0,ROUNDUP(I22/250,0)*IF(AND('COSTING SHEET'!A28="bottom",'INPUT SHEET'!B27="Y"),1.5,1))

[Ben Ash]

Hi Jommo1,

Thanks for the help, this formula is now giving me a tangible result.

It looks to me like the *IF(AND statement nullifies the ROUNDUP section as my reult hasn't rounded up to the correct answer I know it should be.

Is there a way round this?

[Jonmo1]

That's why I asked the question

Do you want that 50% added to the I22/250 Before or After it's rounded ?

And you answered

After its rounded please.

So the formula I posted rounds the result of I22/250
THEN
Adds 50% to the result of that round.

But now it seems you want to
Add 50% to the result if I22/250
THEN
Round that result.

That would be
=IF(D28="",0,ROUNDUP((I22/250)*IF(AND('COSTING SHEET'!A28="bottom",'INPUT SHEET'!B27="Y"),1.5,1),0))