Quote:
Originally Posted by Claus Busch
Hi Kristy,
Am Wed, 11 Feb 2015 06:28:32 +0000 schrieb KristyAlison:
I am trying to create a cell (T5) that refers to another cell (S5) that
contains a value / number, but I don't want the T5 value to exceed 60,
at the same time not fall below 0.
I know the functions of =MIN(60, and =MAX(0, . But is it possible to
have both work together to achieve what I want?
your problem is not really clear. Can you post some examples of numbers
in S5 and the expected output in T5?
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|
Hello Claus, thank you for coming to my aid.
Basically, I am working on a library-based Excel file.
What happens is, the Excel has a check out date (Cell A), and a check in date (Cell B). If books are returned exceeding 30 days (Cell B - Cell A), this would be reflected in Cell C on showing the number of days it's been overdue. A fine would also be calculated in Cell D, $1 is charged for every day overdue, with a maximum of $60 that we are allowed to collect by policy.
The problem is here, at times when books are still not returned over 60 days, (say 61 days), I want the cell to show a maximum of 60 only coz that's the maximum we can collect), at the same time, I don't want cells to show "-42076" when books are not returned yet.
Is there a solution to this?