Styleforum › Forums › General › General Chat › The Excel Questions Thread
New Posts  All Forums:Forum Nav:

The Excel Questions Thread - Page 33

post #481 of 491
1/3/12 at 2:22pm
Quote:
Originally Posted by cahlersmeyer View Post

haha yes, I'm a journalism major... I took MATHS 108 and thats it lol

I guess you skipped over high school algebra.

facepalm.gif
Reply
Reply
post #482 of 491
1/7/12 at 2:27pm
Excel '03

How to make it stop autoformatting things as dates? And don't say "format the cell before you enter a value".
Reply
Reply
post #483 of 491
1/7/12 at 2:41pm
Quote:
Originally Posted by cahlersmeyer View Post

Just found this thread, so glad it exists.
I'm looking into comparing the cost of buying a Soda Stream machine vs buying soda from the store. I'm trying to figure out how many bottles I have to make in order for me to make the 79.99 machine and flavoring supplies worth it vs buying soda from the store. I've seen this excel sheet before, and did it my freshman year in college in my ISOM class, but don't know what its called? Any ideas?

Someone did this on a review of it. You really dont save much, or anything at all. The conclusion was, savings is no reason to buy it.
Reply
Reply
post #484 of 491
1/17/12 at 12:18pm
I have an excel sheet of 25,000 rows where one column consists of 4-6 digit numbers, which sometimes are followed by a letter(A,B,C,D).

Is there any way to automatically remove these letters and place them into an adjoining column?

Existing condition: Column A = 956732C

Desired result: Column A = 956732 & Column B = C

I'm thinking some sort of if statement for column b and then a find and replace to get rid of the letters in column a?

Halp!
Reply
Reply
post #485 of 491
1/17/12 at 12:56pm
Quote:
Originally Posted by Reborn View Post

I have an excel sheet of 25,000 rows where one column consists of 4-6 digit numbers, which sometimes are followed by a letter(A,B,C,D).
Is there any way to automatically remove these letters and place them into an adjoining column?
Existing condition: Column A = 956732C
Desired result: Column A = 956732 & Column B = C
I'm thinking some sort of if statement for column b and then a find and replace to get rid of the letters in column a?
Halp!

Look into the "Delimiter" function.
Reply
Reply
post #486 of 491
1/17/12 at 1:31pm
Quote:
Originally Posted by deadly7 View Post

Excel '03
How to make it stop autoformatting things as dates? And don't say "format the cell before you enter a value".

is prefixing the cell with ' not what you are looking for?

'January 2005

will be displayed as January 2005 but not turned into 1/1/2005 internally.
Reply
Reply
post #487 of 491
1/18/12 at 8:05am
Blanking on this right now: I have a bunch of data and have calculated the days of the week (mon, tues, etc. ) how do I count each day of the week? Same thing if I have a bunch of products how do I count each specific product?
Reply
Reply
post #488 of 491
1/18/12 at 8:48am
Quote:
Originally Posted by stevent View Post

Blanking on this right now: I have a bunch of data and have calculated the days of the week (mon, tues, etc. ) how do I count each day of the week? Same thing if I have a bunch of products how do I count each specific product?

sumifs (or sumif as an array if you don't have office >=2007)

Actually, if you just want to count the days (as opposed to add up some other column based on the days), countif is probably what you are looking for...just be careful with its behavior on non-number values.
Reply
Reply
post #489 of 491
1/18/12 at 2:55pm
Quote:
Originally Posted by otc View Post

sumifs (or sumif as an array if you don't have office >=2007)
Actually, if you just want to count the days (as opposed to add up some other column based on the days), countif is probably what you are looking for...just be careful with its behavior on non-number values.


Yeah that could work. Ended up just doing pivot tables
Reply
Reply
post #490 of 491
4/5/12 at 4:56pm
I need some help with an if then statement. I'm trying to have a cell auto convert currency depending on the currency label:

=if((AND($F6=1,$AJ6="KRW"),$AI6*Settings!$D$7($F6=1,$AJ6>="JPY"),$AI6*Settings!$D$8))

This yields an error.

This works:
=if(AND($F6=1,$AJ6="KRW"),$AI6*Settings!$D$7)

but I need to have it be able to pull in different conversion rates from the Settings worksheet depending on the currency label in AJ6.

Thanks!
Reply
Reply
post #491 of 491
4/5/12 at 8:08pm
you gotta tell us more about the error.

If you can go into the debug mode, where in the evaluation does it hit a snag? really though if that is copy pasted exactly, you've got an extra parentheses in front of the and and you seem to be missing a comma after Settings!$D$7

Really though, I think your life would be easier if you created a hidden column with the exchange rate and set that equal to a lookup (or index-match) to the currency conversion table on your settings page....that way it would work with any number of currencies where as now you would need more and more nested if statements.
Reply
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: General Chat
Styleforum › Forums › General › General Chat › The Excel Questions Thread