I have been trying to set up a spread sheet for inventory. I have a problem with trying to solve the formula for the following argument:
In cell a1 is the date of purchase
In cell b1 is the date of sell
In cell c1 is the number of days in inventory - I have b1-a1 gives me number of days
But I need : if the number of days are greater than 31 then write "reduce" in column instead of the number of days. Any help is greatly appreciated.
Bookmarks