• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 40848
Experience:  Over 15 years of consulting to the IT industry
32989067
Type Your Computer Question Here...
Richard is online now

This answer was rated:
have uploaded it as

and
Thanks

Looking at it now Roger

Customer: replied 3 years ago.

have uploaded it as

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

Thanks

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

Customer: replied 3 years ago.

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

also no formula in S and T

You never specified S & T Roger.

Look above and you see this.

What do you need for S & T?
Customer: replied 3 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

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 3 years ago.

what was down load number

thank you roger

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 3 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,

Not before I understand how it does not collect any data required.

Give an example please.

Customer: replied 3 years ago.

formulas do not work at all see your 182530 download

nothing works

thank you

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 3 years ago.

 amz026-9711128-0585100 ######## 21.81 17.81 4 AMAZON PAID AU Y

amz026-9711128-0585100 is not amz026

Customer: replied 3 years ago.

that is not showing any values

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

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

how to do this

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

yes, but give me some time as I need to redo all the formulas again
Done Roger, also S and T added.

File ID is 410940

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

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

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 and 5 other Computer Specialists are ready to help you