Syntax for formula

[minnie]

Here's the English version:
If cell E47 (which is age in months) is >=600 but <=660, then take E47 and subtract it from 720 and multiply it by .005 and multiply the result by cell D40 (which is a dollar amount).

Thanks for you help.

 

[Aladin Akyurek]

On 2002-05-01 12:35, minnie wrote:
Here's the English version:
If cell E47 (which is age in months) is >=600 but <=660, then take E47 and subtract it from 720 and multiply it by .005 and multiply the result by cell D40 (which is a dollar amount).

Thanks for you help.

=IF(AND(E47>=660,E47<=720),(720-E47)*.005*D40,"")

Aladin