Floor and Ceiling function help

[MM_Chris]

Hi there,

I was wondering if there was a way to parse through data and see which values need to be rounded either up or down. I know we have the floor or ceiling formulas, but would REGEX be useful for this case to check the decimal value to make sure whether that value needs to be rounded up or down?

Thank you.

[Matt_Sinker]

Hi again, sorry to be a pain.

How would I go about writing a similar formula: 

=IF([SS]-[Store Needs Units]<0,0,[SS]-[Store Needs Units])

[Matt_Sinker]

This is what I have, but it isn't working:

IF [Store Need Units]-[SafetyStock]<0 THEN 0 ELSE [Store Need Units]-[SafetyStock] ENDIF

[mceleavey]

Hi @Matt_Sinker, no problem.

IF([SS]-[Store Needs Units])<0 then 0 ELSE ([SS]-[Store Needs Units]) ENDIF