Forumals within a sentance...

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

What is the correct formulas to these examples below?

Question 1: John Doe has 'sum(A1:R1)' apples in his
basket.

Question 2: On average, John Doe gets 'average(A1:R1)
apples perday.

Question 3:

And here's the big one...

A1 = 5 (Submitted Orders)
B1 = 4 (Submitted Orders)
C1 = 9 (Submitted Orders)

A2 = 2 (Rejected Orders)
B2 = 1 (Rejected Orders)
C2 = 4 (Rejected Orders)

This is what I want my answer to look like...

John Doe has placed 18 orders, ofwhich 7/39% of them were
rejected.
 
Hi Jay

this is basically what Dave R, Andy B, Vaughan and me have given you in your
last post (Summing in a sentance ...)
which bit are you still unsure of?

Cheers
JulieD
 
JulieD,

My origional post, only covers the first question in my
second posting. But even after those examples you all
gave me, I still can't get it to work correctly. It
returns a value error.

Also, my new post has other examples of formula's I'd
need. I do my best in trying to find the answers myself,
but with these specific questions, I can't find the
answers on my own. And I don't know enough about
formula's to put it together myself.

Would it be easier if I e-mailed you a spreadsheet
with 'exactly' what I'm looking for?

I'm sorry to be so confusing in my postings.

Jay
 
Hi Jay

okay, let's start with your original question ...
*********
A1 = 10
B1 = 10

C1 = "There are 20 apples total"
*********
what happens when in C1 you type (and type exactly as shown below)
="There are " & sum(A1:B1) & " apples total"
and press enter (you can copy & paste the above in)

Cheers
JulieD
 
JulieD,

That one worked perfectly. I know what my mistake was now.

Now there's two questions left.
 
Hi Jay,
For Q3 try:
="John Doe has placed "&sum(a1:c1)&" orders, of which "&sum
(a2:c2)&"/"&text(sum(a2:c2)/sum(a1:c1),"0%")&" of them
were rejected."
 
Hi Jay,
For Q3 try:
="John Doe has placed "&sum(a1:c1)&" orders, of which "&sum
(a2:c2)&"/"&text(sum(a2:c2)/sum(a1:c1),"0%")&" of them
were rejected."
 
Hi Jay

the second answer is exactly the same as the first, just using a different
function - BTW this isn't homework is it?

When you've got that i'll help you with the 3rd!

Cheers
JulieD
 
My apologies, Julie - didn't mean to intrude. My screen
wasn't showing your dialog with Jay until after my post.
Mea culpa.
 
Hi hcj

no need to apologise .. all input welcome - i was just trying to encourage
him to do it without simply handing him the answers :) - its the teacher in
me coming out :)

Cheers
JulieD
 
JulieD,

This one worked perfectly as well.

As for my Q2, well, Q1 helped me on that one. Just
replaced 'sum' with 'average'.

Thank you VERY much for your help. I appreciate it.
 
Back
Top