It is also unclear what you want in H1 if they are equal blank is no
problem, but if they are not equal what do you wish to do. this assumes
b1 is a date, in your origianl post it is a1/6 but guess that is a
typo.
in c1 if(b10,round($a1/6,2),"")
in G1 if(b10,a1-sum(c1-f1),"")
in H1 If(b1=max(c1:f1),"",what do you want to do if it is not true?)
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=572451