• ### Excel question. Can excel sort and total data as its input?

have 5 receipts - \$42.00, \$220.00, \$55.00, \$100.00 and \$25.00. For example i want them to be sorted into 3 categories food, gas, entertainment. Is there a way using the IF function or something else that if i entered them as fallowed in cells c4:c9 they would be automatically sorted and totaled. 42g 55g 220f 100f 25e result... show more
have 5 receipts - \$42.00, \$220.00, \$55.00, \$100.00 and \$25.00. For example i want them to be sorted into 3 categories food, gas, entertainment. Is there a way using the IF function or something else that if i entered them as fallowed in cells c4:c9 they would be automatically sorted and totaled. 42g 55g 220f 100f 25e result would be \$97.00 gas, \$220.00 Food, \$25.00 Entertainment in lets says cells E7,E8,E9 accordingly?
2 answers · Software · 9 years ago
• ### Probability. Suppose that one rolls a die.?

Suppose that one rolls a die. If the value is 1,2,3,4 the player wins a doller. If its 5,6 the player loses a dollar. Whats my expected return? \$.33?
Suppose that one rolls a die. If the value is 1,2,3,4 the player wins a doller. If its 5,6 the player loses a dollar. Whats my expected return? \$.33?
3 answers · Mathematics · 10 years ago
• ### Excel ms, can i get the background color to changeof a cell, once the text is input?

Eg. I have a form that need certain cells filled out. Can i have those cells eg. A3, g3, f3 with a yellow background when no data is entered. Than, when data is present the background will automatically go to "no fill" or blank. Is there any way of doing this besides manually having to change it by formating? Thanks
Eg. I have a form that need certain cells filled out. Can i have those cells eg. A3, g3, f3 with a yellow background when no data is entered. Than, when data is present the background will automatically go to "no fill" or blank. Is there any way of doing this besides manually having to change it by formating? Thanks
2 answers · Software · 10 years ago
• ### I am constantly getting hit by different trojans 10-20 times a day. How do i stop this?

I am running windows xp service pack 3. Trend Micro Internt Security Pro Trojan Remover, Hijackthis I am picking them up right away, but i can't stop them from coming in. This has just happened in the last 4 days. Even when not using computer (internet still connected). All settings are at maximum sensitivity Anysuggestions. Thanks
I am running windows xp service pack 3. Trend Micro Internt Security Pro Trojan Remover, Hijackthis I am picking them up right away, but i can't stop them from coming in. This has just happened in the last 4 days. Even when not using computer (internet still connected). All settings are at maximum sensitivity Anysuggestions. Thanks
1 answer · Security · 10 years ago
• ### Excel multiple outcomes.?

Here is an example of what i need, just don't know what formula to use. If a2 = 80 i need the fallowing formula if a2 is less that 60 multiple by factor of 2.08, if a2 is between 61-80 multiple by factor of 2.88 if a 2 is between 81 - 130 multiple by factor of 2.99 Is there someway i can do this all in 1 formula. The IF formula in... show more
Here is an example of what i need, just don't know what formula to use. If a2 = 80 i need the fallowing formula if a2 is less that 60 multiple by factor of 2.08, if a2 is between 61-80 multiple by factor of 2.88 if a 2 is between 81 - 130 multiple by factor of 2.99 Is there someway i can do this all in 1 formula. The IF formula in excel only lets you do true or false to my knowledge Thanks
1 answer · Software · 10 years ago
• ### Using binary how would you use clipping of nails to id 2096 rats?

1 answer · Mathematics · 10 years ago
• ### How do i get my monitor & hard drive to shut off in standby? (xp pro sp2)?

I have adjusted my power saver options so they turn off after 2 hrs, but if i put it in standby for night the monitor and everything remains on all night.
I have adjusted my power saver options so they turn off after 2 hrs, but if i put it in standby for night the monitor and everything remains on all night.

• ### Want to put system mechanic 7 on new comp, have it on old. Lost case. Can i get S/n off old system somehow?

System Mechanic 7 (not pro edition)
System Mechanic 7 (not pro edition)