Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please help!
What the heck am I supposed to do here- 1 What is $B$3/G4, $B$3/G5, & $B$3/G6? 2 What is B5/E4? 3 What is $E$2/G5, $E$2/G3, AND $E$2/G7? 4 What is $C$4*E2, $C$4*E5, & $C$4*E6 What function would I use ? Thanks much for any help -- morrison ------------------------------------------------------------------------ morrison's Profile: http://www.excelforum.com/member.php...o&userid=27975 View this thread: http://www.excelforum.com/showthread...hreadid=474811 |
#2
|
|||
|
|||
<< 1 What is $B$3/G4 Whatever is in Cell B3 will be divided by whatever is in Cell G4 (obviously, these should be numbers). << $B$3/G5 Whatever is in Cell B3 will be divided by whatever is in Cell G5 << $B$3/G6? Whatever is in Cell B3 will be divided by whatever is in Cell G6 << 2 What is B5/E4? 3 What is $E$2/G5, $E$2/G3, AND $E$2/G7? Same explanation as above. << 4 What is $C$4*E2 Whatever is in Cell C4 will be multiplied by whatever is in Cell E2. <<$C$4*E5 Whatever is in Cell C4 will be multiplied by whatever is in Cell E5. << $C$4*E6 Whatever is in Cell C4 will be multiplied by whatever is in Cell E6 << What function would I use ? It really depends on what you want to do! << Thanks much for any help You are welcome ... Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=474811 |
#3
|
|||
|
|||
You are deviding and multiplying absolute numbers if # are in B3. THe dollar
sighns are absolute references which means that number will never change. "morrison" wrote: What the heck am I supposed to do here- 1 What is $B$3/G4, $B$3/G5, & $B$3/G6? 2 What is B5/E4? 3 What is $E$2/G5, $E$2/G3, AND $E$2/G7? 4 What is $C$4*E2, $C$4*E5, & $C$4*E6 What function would I use ? Thanks much for any help -- morrison ------------------------------------------------------------------------ morrison's Profile: http://www.excelforum.com/member.php...o&userid=27975 View this thread: http://www.excelforum.com/showthread...hreadid=474811 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|