Jo

Certainly, check out the IF function and you can nest these like so

=IF(Test,Value_If_True,IF(Test,Value_if_True,Value _If_False))

This is only set out to show the approx syntax. If you want an exact
formula then try and let us now the cells you are using, where we get the
date from, etc (A little more clearly)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Joe Black" wrote in message
...
i am trying to work out a formula to:
calculate a cell but only if another cell is of greater value than
another,(if not then value in cell = 0) then if the value is greater and
the
date is under 365 days calculates at %50 rate and if its over, calculate
at
%25 rate. can i do this from one cell/one formula