help with a function
 

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.

Perhaps something like:
IF(A1B1,IF(B1365,B1*0.25,B1*0.5),0)

Per Erik
On Fri, 6 May 2005 21:46:01 -0700, Joe
wrote:

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.