Need help with Microsoft excel...

[ashdavid]

I need to show the number of hours worked in a week and I need to have excell do the math for me as it gets pretty complicated towards the end.(I can do that part of it) What I need is for the circled ① (#1 ) to show up like it is on the form ,but somehow have the ① represent for example 8 (for 8 hours), I can then have excell do the math of 8 X 20 to get 160(#3) hours. Is there a way to do this? I hope I explained it correctly.
http://forums.waterwolves.com/uploads/post-9939-1206497878.jpg

[beezwax]

enter in the cell that you are trying to get a total in this formual:

=sum("first cell in chain":"last cell in chain")

press enter... that is the addition or "sum" formula for totals.

this was no matter what number you enter in, the total will always remain up to date.

same rule applies to any mathematical formula.

if you select a cell... click the button highlighted here:

http://i79.photobucket.com/albums/j130/bwaxman1980/excel01.jpg

it'll allow you to select a range of cell to perform a function


hope this helps

[ashdavid]

Thats not working for me, b/c I need the formula to use the number 8 not the circled number "1" . It is like I need two cells in one but only have one cell show sort of like having one cell on top of each other, one for entering the number I need to have calculated and the other to show what I want shown.


Or I could be just totally missing what you are trying to say, if that is the case I am sorry.

[beezwax]

ok...

if 1 ALWAYS =8 then use


=sum(start cell:end cell)*8

[ashdavid]

ok...

if 1 ALWAYS =8 then use


=sum(start cell:end cell)*8
That is not working either b/c the circled 1 (①) is not being recognized as anything . Sorry to be such a pain.

I need the circled 1 (①) to be recognized as the number 8 but still show up as the circled 1 (①) when printing the form out. What I was thinking is that I need to set the cell up so that the circled 1 (①) will be recognized as the number 8 and then just use the "SUM" button like I always do when making an equation.

[beezwax]

oh...ok

this is where is get's REALLY fun

use the IF THEN function...to tell excel that (circle 1) = 8(number)

if (circle 1)=8, then 8 - this function should be placed at the END of your cell string. Then fill the function down using the $ sign before the cell letter and after the cell letter.. that will lock in the colum and not the row, since the row value is the one that changes, right?

thhhhhhennnnnn....

THEN... create a pivot table that reads the value from the IF THEN statement and multiply it by 8...

how far did I throw you off on that one?


also... WTF do you have to have that 1 circled.

<---- going to sleep, will catch up in the morning...

[DennisE]

Hi Ashdavid
Try this
Put in any symbol your require in a cell eg: C9
In the cell you require to put the symbol in add symbol eg: D9
In next cell eg E9 type =EXACT(C9,D9)
In next cell eg F9 type =COUNTIF(E9,"true")*8

Always refer back to C9 and the cell you are in
This should give you number 8 in the cell you are working on eg F9
Go to format column hide will hide any columns you dont need to see.

Hope this makes sense bit long winded biut it worked for me when I tried it.

Regards Dennis

[beezwax]

Hi Ashdavid
Try this
Put in any symbol your require in a cell eg: C9
In the cell you require to put the symbol in add symbol eg: D9
In next cell eg E9 type =EXACT(C9,D9)
In next cell eg F9 type =COUNTIF(E9,"true")*8

Always refer back to C9 and the cell you are in
This should give you number 8 in the cell you are working on eg F9
Go to format column hide will hide any columns you dont need to see.

Hope this makes sense bit long winded biut it worked for me when I tried it.

Regards Dennis


wow... I totally forgot about true false statements... this should work like a charm

[RTMiller]

I'm not sure I understand why you are using a symbol or if I even understand the question but have a look at this...

http://rtmiller.smugmug.com/photos/270747436_pBchZ-L.jpg

[RTMiller]

To be more precise and in line with your format...

http://rtmiller.smugmug.com/photos/270753112_RzDgi-XL.jpg

[ashdavid]

Thanks so much guys for your help, I have learnt so much.

@beezwax, I don't quite follow what you said but there was something I saw when researching this and using the $ sign for creating a situation like I want(I just don't know how to do it)

@DennisE, I don't follow that either, if you had a screen shot it would make things a little more understandable(sorry ,using japanese excell)

@RTMiller, I just tried what you have suggested and it works like a charm, and you went one step further with your last post! That is exactly what I was looking for but I could not get the " =AD4*8 " to work. Do I need to put something in front of it?

Again thanks everyone for your help, these are forms to be submitted into government agencies and they can't be changed, but I wanted to make things more efficient and have excell do the math for me. Cheers

[ashdavid]

In regards to my last question never mind , I was putting in the wrong cell number, I have got it to work now. Thanks RTMiller!:D

[DennisE]

Well done RTMiller I think your solution much simpler and better than mine
Dennis

[RTMiller]

Thanks RTMiller!:D

非常に歓迎されている

[ashdavid]

非常に歓迎されている
（笑）。。。すばらしい！非常に助かりました！;)