• 100% Satisfaction Guarantee

Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32264
Experience:  Over 15 years of consulting to the IT industry
32989067
Richard is online now

### Resolved Question:

and
Submitted: 2 years ago.
Category: Computer
Expert:  Richard replied 2 years ago.
Thanks

Looking at it now Roger

Customer: replied 2 years ago.

M £ requires value from D only when order number A=amz026,=amz204, amz202, amz203, BTF and J=Y

N = Euro value from D only when order number A

=amz028, amz403,amz302, amz402, amz304, amz404, and J=Y

O = \$ value from D when L = Y and order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,

amz108, amz109, amz110, amz111, amz112, and OP

P = yen value from D when L = Y and order number =A =amz249, amz503,

Q= £non requires value from c only when order number A=amz026,=amz204, amz202, amz203, BTF and J=Y

R = euronon Euro value from C only when order number A

=amz028, amz403,amz302, amz402, amz304, amz404, and J=Y

S=\$ non

O = \$ value from C when order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,

amz108, amz109, amz110, amz111, amz112, and OP and J=Y

P = yen value from C when order number =A =amz249, amz503, and J=Y

thank you roger

Expert:  Richard replied 2 years ago.
Thanks

Doing it now for you, will let you know when it is done.

Customer: replied 2 years ago.

entered the formulas but they show blank see this upload to you

also no formula in S and T

Expert:  Richard replied 2 years ago.
You never specified S & T Roger.

Look above and you see this.

What do you need for S & T?
Customer: replied 2 years ago.

T = yen value from C when order number =A =amz249, amz503, and J=Y

S = \$non value from C when order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,

my mistake

but there were no values in any of formulas MNOPQRst when run down sheet

Expert:  Richard replied 2 years ago.
Roger,

Your not looking at my sheet, I gave you a .xls file as it needs to be this.

Your not looking at the sheet I gave you

Customer: replied 2 years ago.

thank you roger

Expert:  Richard replied 2 years ago.
It wasn't Roger, as its not even the same name file.

I will re-give it, it is

182530

It has the extension .xls

Customer: replied 2 years ago.

it still does not collect any data as required

also please enter the S and T formulas

T = yen value from C when order number =A =amz249, amz503, and J=Y

S = \$non value from C when order number =A =amz002, amz102, amz103, amz104, amz105, amz106, amz107,

Expert:  Richard replied 2 years ago.
Not before I understand how it does not collect any data required.

Customer: replied 2 years ago.

nothing works

thank you

Expert:  Richard replied 2 years ago.
If I set the criteria to meet the conditions they work for me.

So Roger, a proper clear example, with Row and Cells of one that is not working.

Customer: replied 2 years ago.

 amz026-9711128-0585100 ######## 21.81 17.81 4 AMAZON PAID AU Y
Expert:  Richard replied 2 years ago.

amz026-9711128-0585100 is not amz026

Customer: replied 2 years ago.

that is not showing any values

Expert:  Richard replied 2 years ago.
Roger, Look at the ID number, it does not match what you wanted the formula to match
Customer: replied 2 years ago.

well how do we put this number in can split the row to 5 letters

how to do this

Expert:  Richard replied 2 years ago.
I dont understand your response Roger.

Sorry, but I did a lot of work on this, and I feel you are not really making an effort to explain your requirements.

You are showing me sheets with ID's that do not match what you asked me to do.

eg:M £ requires value from D only when order number A=amz026,=amz204, amz202, amz203, BTF and J=Y

And your not telling me everything you want at the start.

I kindly ask roger you take the time and effort to explain what it is you want, in completeness.

Customer: replied 2 years ago.

sorry that is because I am 80 years old etc. dealing with this spread sheet with four currencies and even different order numbers fior each currency

it seems now that the order numbers "amz etc" in cell a I gave you will have to be split into another cell so that the formula will pick up the different order number sequences.

this should make it work will it not as we can not have any more order number ids

thank you roger

Expert:  Richard replied 2 years ago.
yes, but give me some time as I need to redo all the formulas again
Expert:  Richard replied 2 years ago.
Done Roger, also S and T added.

File ID is 410940

Let me know if you have any difficulties please
Customer: replied 2 years ago.

that looks like it but will check it out tomorrow thank you roger

Expert:  Richard replied 2 years ago.
No problem Roger.

The question stays open, so any problems, just let me know

If you would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32264
Experience: Over 15 years of consulting to the IT industry

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• ### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### James K.

#### Satisfied Customers:

93
Technical Director of IT Company

### Jon-Tech

#### Satisfied Customers:

61
20 yrs: Computers, Networking

### MikeW

#### Satisfied Customers:

53
32+ years Computer and Networking Experience

### jamieratliff

#### Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

### TheDoctor

#### Satisfied Customers:

16
Experienced Software Engineer

### Bill Fisher

#### Satisfied Customers:

1
Computer system design, networks, integration, general support.