Min / Max together
Hi Kristy,
Am Wed, 11 Feb 2015 07:56:28 +0000 schrieb KristyAlison:
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.
in C1 try:
=IF(B1-A130,B1-A1-30,0)
and in D1 try:
=MIN(C1,60)
Format columns C and D with custom numberformat:
0;-0;
The last semicolon is important to avoid dispaying 0
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|