Syntax for formula

minnie · May 1st, 2002, 01:35 PM

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 · May 1st, 2002, 01:39 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 01:35 PM	#1
minnie New Member Join Date: Apr 2002 Posts: 28	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.