Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
if statement help pls
Name: fonzio Date: November 13, 2008 at 08:49:35 Pacific OS: winxp CPU/Ram: 2 gig Product: thermaltake
Comment:
hi
i am trying to take the values from G17:J17 and write an if statement such as if G17:J17 is =8 then display in G19 "correct" if between 4 and 7 display in G19 "random" and if below 4 display in G19 "error", wondering how i would go about this, please help as ive gotten a headache.
Name: Elinor Date: November 14, 2008 at 15:23:17 Pacific
Reply:
Hi Fonzio,
I am assuming from what you said that you are probably working with Excel, in which case you may have more luck with answers in the 'Office Software' forum.
What do you mean by "G17:J17 is =8"? Do you mean the sum of those cells?
Name: Jennifer SUMN Date: November 18, 2008 at 15:39:57 Pacific
Reply:
Ditto. If that's the case, DON'T repost! You'd want to sum the cell values and use that value in your formula, which would be placed in cell G19. You would want a nested "IF" statement, but what should the value in G19 show if the sum of the fields is greater than 8? Also, by "Between 4 and 7" do you mean if the value is 5 or 6? Or... if it's equal to 4, 5, 6, or 7? You're question isn't clear.
"So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown
Summary: I need the following if statement in a word merge 'if statement' format. I really don't know how microsoft word structure their "If LOOPS" THIS is what I need converted into a Word If statement ######...
Summary: Hello!! i need some help in building a sql server select statement: i have a table with these columns and info: product_id | quantity ------------------------ prod1 | 2 prod1 | ...
Summary: Both mdow and babaji have correct solutions (And Michael, except the join should be a left join as mdow suggested) , but mdow's will be much, much faster. You should avoid having subqueries in the WH...
0 
