1. ## Formula

HI

Can anybody help with this one please,see attached

2. ## Re: Formula

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

3. ## 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

4. ## Re: Formula

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

5. ## Re: Formula

Hi

Sorry to be a pain, But I tried the current cell formula and got a name error.

6. ## 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. ## 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

8. ## Re: Formula

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

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

9. ## 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.

10. ## 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. ## Re: Formula

Hi Steve

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

Regards

#### Posting Permissions

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