Using "roundup" in an "if" statement

[Reaper65]

I need help with roundup in an if statement.

=IF(TEXT(A11,"mm/dd/yyyy")<"1/1/2013",0.565*D11,0.555*D11)

I've tried everything that I can think of with no luck.

Any help would be appreciated.

 

[MrKowz]

I need help with roundup in an if statement.

=IF(TEXT(A11,"mm/dd/yyyy")<"1/1/2013",0.565*D11,0.555*D11)

I've tried everything that I can think of with no luck.

Any help would be appreciated.

Try:

=ROUNDUP(IF(A11 < DATE(2013,1,1),0.565*D11,0.555*D11),2)

This should roundup the value to the nearest 2 decimal places.

 

[Reaper65]

Works perfect...you're the man.

Thanks much!

 

[MrKowz]

Works perfect...your the man.

Thanks much!

Not a problem, thanks for the feedback.

 

[jim may]

Deleting a note doesn't seem to be an Option....