addition of =ROUNDUP, causes function to become 'text' in formula bar

[MikeCS]

Hi all.
I have a function below which compares two values to two reference cells and works as expected:
=IF(
OR(
AND(
AL33 >= $AW$15,
AM33 < $ AW$15),
AND(
AL33 >= $AW$17,
AM33 < $AW$17)
),"Y","")

However, when I add =ROUNDUP in the formula it isn't recognized as a formula, and instead becomes orange text with no error message.
=IF(
OR(
AND(
=ROUNDUP(AL33,0) >= $AW$15,
=ROUNDUP(AM33,0) < $AW$15),
AND(
=ROUNDUP(AL33,0) >= $AW$17,
=ROUNDUP(AM33,0) < $AW$17)
),"Y","")

Any help would be appreciated,

Thanking you in advance.

--Mike

 

[jtakw]

Hi,

You don't need the equal sign = in front of ROUNDUP:

Book1
	B	C	D
1
Sheet1

Cell Formulas
Range	Formula
B1	=IF(OR(AND(AL33>=$AW$15,AM33<$AW$15),AND(AL33>=$AW$17,AM33<$AW$17)),"Y","")
D1	=IF(OR(AND(ROUNDUP(AL33,0)>=$AW$15,ROUNDUP(AM33,0)<$AW$15),AND(ROUNDUP(AL33,0)>= $AW$17,ROUNDUP(AM33,0)<$AW$17) ),"Y","")

 

[mrhstn]

Take out the = sign before each ROUNDUP.