How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Sales U style # wk1 wk2 wk3 wk4 wk5 wk6 first Wks with >5

Customer Question

Sales U
style # wk1 wk2 wk3 wk4 wk5 wk6 first Wks with >5 U sold
1111S 5 10 12 3 6 1 wk2
1112S 20 15 18 20 10 5
1114S 3 2 6 1 1 1
* Add formula to blue cells that display the first week where the sale U is great than 5
* Do not use nested if statement
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Jess M. replied 1 year ago.

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

Can you please send me a sample Excel file where you got this data so that I can directly check and build the formula for you?

You can upload the sample Excel file using the paper clip icon in the reply box, or you can upload it to:

http://filesXpress.com

and then give me the short download link.

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Customer: replied 1 year ago.
Hi Jess, here it is.
Expert:  Jess M. replied 1 year ago.

Thank you. Please give me a moment to download the file and work on the formula for you.

Best regards,

Jess

Customer: replied 1 year ago.
Sorry i forgot to add
* Do not use nested if statement
Expert:  Jess M. replied 1 year ago.

Thank you for the confirmation. Please give me a moment to work on this. I will get back to you in a while.

Customer: replied 1 year ago.
Hi Jess here is one more for today.
Expert:  Jess M. replied 1 year ago.

Oh Ok, I will look into that shortly.