Results 1 to 11 of 11

Thread: Formula

  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Formula

    HI

    Can anybody help with this one please,see attached
    Attached Images Attached Images
    If you are a fool at forty, you will always be a fool

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Formula

    =if(f5="ireland",E$1*d4,"")

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula

    Hi

    The problem with your formula leaves a blank cell it column F reads England, I need the formula to leave alone the cell if column F = England

    Thanks
    If you are a fool at forty, you will always be a fool

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    153
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Formula

    =if(f5="ireland",E$1*d4,current cell)

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula

    Hi

    Sorry to be a pain, But I tried the current cell formula and got a name error.
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula

    What Jim probably meant is that the "Else" part of the function must contain a reference to the cell whose value you want to be displayed if the country is not Ireland. I don't know what you're trying to accomplish here; do you want an amount in sterling or in euros to appear in column E, depending on the country? It seems strange, since the column header says "Quoted Price

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula

    Hi Hans

    We have Irish Agents who always quote in euros. What I want to do is convert the euro values by the exchange rate and put it into column D so that I can sum the total value in sterling.

    Because the Sterling is entered in column D directly no convesion is required

    Hope this is clear
    If you are a fool at forty, you will always be a fool

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula

    =if(f5="ireland",E$1*d4,d4)

    will put converted values if ireland, nonconverted if anything else
    Steve

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula

    Hi Steve

    Thanks for your patience, you would never know I'm a novice I was trying to put the result in the same column as I had entered the data Doh.

    Thanks for your patience you formula works fine, But I guess you knew that.

    Thanks Braddy
    If you are a fool at forty, you will always be a fool

  10. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula

    From your example it looked like you wanted it blank, except for ireland. I think this is what caused the confusion.
    Steve

  11. #11
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula

    Hi Steve

    I am sorry about that I wil try to be more precise in the future.

    Regards
    If you are a fool at forty, you will always be a fool

Posting Permissions

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