+ Reply to Thread
Results 1 to 2 of 2

IF formula?

  1. #1
    meris
    Guest

    IF formula?

    Im trying to create a couple of formulas from the following data, Im using an
    IF formula at the moment, but I keep getting an error message: My data

    O T pN pJ
    nor 100 (1st formula) (2nd Formula)
    jme 100 (1st formula) (2nd Formula)

    For the 1st formula, If O is nor, pN= 60% of T and if O is jme, pN = 0


    And 2nd formula, If O is jme, pN = 0, and pJ = 60% of T

    Here’s what I want it to look like

    O T pN pJ
    nor 100 60 0
    jme 100 0 60

    The only things I should mention is that the value of T is a result of
    another formula, but I don’t think that should matter? And, O is a word, not
    a number…how do I represent a word in a formula?

    Thanks for your help!


  2. #2
    Arvi Laanemets
    Guest

    Re: IF formula?

    Hi

    pN=(O="nor")*0.6*T
    pJ=(O="jme")*0.6*T


    --
    Arvi Laanemets
    ( My real mail address: arvil<at>tarkon.ee )



    "meris" <meris@discussions.microsoft.com> wrote in message
    news:51BB04FF-9B9C-43A9-A561-E5C1F7249E61@microsoft.com...
    > Im trying to create a couple of formulas from the following data, Im using
    > an
    > IF formula at the moment, but I keep getting an error message: My data
    >
    > O T pN pJ
    > nor 100 (1st formula) (2nd Formula)
    > jme 100 (1st formula) (2nd Formula)
    >
    > For the 1st formula, If O is nor, pN= 60% of T and if O is jme, pN = 0
    >
    >
    > And 2nd formula, If O is jme, pN = 0, and pJ = 60% of T
    >
    > Heres what I want it to look like
    >
    > O T pN pJ
    > nor 100 60 0
    > jme 100 0 60
    >
    > The only things I should mention is that the value of T is a result of
    > another formula, but I dont think that should matter? And, O is a word,
    > not
    > a numberhow do I represent a word in a formula?
    >
    > Thanks for your help!
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1