One way...

=IF(MOD(A1,30),"","Re-order")

--
Biff
Microsoft Excel MVP


"Amin" wrote in message
...
Hi i have an inventory table where a column is to remind me of reordering
but my approach is not helping me so i need a help.

i have a column in a different sheet with a sum if function and i want to
have a column to watch it for figures like 30, 60 90 120 150 180 unwards,
so
that anytime a cell in that column reaches that figure it will remind me
to
reorder that product.

i will use a conditional format to show some colours in the reorder
column.
please help me with this. i know if i just use he IF function like
IF(A1=30"Reorder","Available") it will be for only that but i want to be
reminded of the next 30 that makes it 60 and son on thank you so much