Excel Formula

Discussion in 'Microsoft Certification' started by =?Utf-8?B?QyBBbmRlcnNvbg==?=, Apr 12, 2006.

  1. I am having trouble trying to make a formula work.

    what I am trying to do is this. I have text in one cell ie Townsville,
    Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet
    to take the value from an adjacent cell and *0.44%*50/25. If the value of
    the cell is Townsville then I need the worksheet to take the value from the
    adjacent cell and *0.44%*35/25. If the value is anything else I need the
    worksheet to take the value from the adjacent cell and *0.36%*35/25

    Can anyone help me with this delimnar
    =?Utf-8?B?QyBBbmRlcnNvbg==?=, Apr 12, 2006
    #1
    1. Advertising

  2. Please repost your question in the Excel newsgroup:
    http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

    --
    Carey Frisch
    Microsoft MVP
    Windows - Shell/User
    Microsoft Community Newsgroups
    news://msnews.microsoft.com/

    ---------------------------------------------------------------------------­----------------

    "C Anderson" wrote:

    | I am having trouble trying to make a formula work.
    |
    | what I am trying to do is this. I have text in one cell ie Townsville,
    | Sydney, Brisbane. If I have Brisbane in the cell then I need the worksheet
    | to take the value from an adjacent cell and *0.44%*50/25. If the value of
    | the cell is Townsville then I need the worksheet to take the value from the
    | adjacent cell and *0.44%*35/25. If the value is anything else I need the
    | worksheet to take the value from the adjacent cell and *0.36%*35/25
    |
    | Can anyone help me with this delimnar
    Carey Frisch [MVP], Apr 12, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Doug

    Excel 2003 Formula

    Doug, Feb 15, 2004, in forum: Microsoft Certification
    Replies:
    0
    Views:
    558
  2. Max Sand

    Excel formula for this...

    Max Sand, Sep 2, 2003, in forum: Computer Support
    Replies:
    6
    Views:
    641
  3. sunny

    Simple Excel formula required

    sunny, Jan 6, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    679
  4. Katherine Colby

    -Excel Formula Question

    Katherine Colby, Jan 12, 2004, in forum: Computer Support
    Replies:
    3
    Views:
    594
  5. *

    Re: Excel formula help

    *, Apr 2, 2005, in forum: Computer Support
    Replies:
    4
    Views:
    691
    Buckaroo Banzai
    Apr 3, 2005
Loading...

Share This Page