Try this:

=IF(AND(C1A1,C1B1),D1=0,IF(AND(C1A1,C1<B1),D1=C 1-B1,IF(AND(C1<A1,C1<B1),D1=A1-B1,IF(AND(C1<A1,C1B1),D1=A1-C1))))

--
sandyboy


"spaceage" wrote:

i wud like to put this formula in excel,if someone can please guide me,

if c1a1 and if c1b1 then d1=0,
if c1a1 and if c1<b1 then d1=c1-b1
if c1<a1 and if c1<b1 then d1=a1-b1
and
if c1<a1 and c1b1 then d1=a1-c1
--
thanks and
rgds

amit