Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Syntax for formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,993
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •