Function:Please help!

[morrison]

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

[BenjieLop]

<< 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.

[musicbox.4]

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
>
>