newbie excel question

[kreactor]

i'm reading the excel help files on about.com while tryin to make an excel spread
sheet to keep a running count of my vacation /holiday hours, but don't know
how to accomplish the following

instead of goin to cell b6 and type =B4/7.5 then c6 =c4/7.5 then d6, manually etc

how would i go about it so that it would automatically select the corresponding
column *4 value and dividing by 7.5, some sort of global column change function

also is there such a function/formula so if condition a is true, then use this formula
i.e. if b2/3.3 > 4.4 then resultant value /3 and if condition b is true, value/2)

(trying to refine my work calculation worksheet)
http://s91258720.onlinehome.us/tpncalc.htm

thanks for all the help!

 

[ArmenK]

=A$4/7.5, copy, paste or just drag the bottom right corner

also: IF(logical_test,value_if_true,value_if_false)

 

[NikPreviousAcct]

http://forums.anandtech.com/categories.aspx?catid=33&flcache=242642&entercat=y

 

[isasir]

Click on cell b6. PUt the mouse on the bottom right corner and you'll see a black + sign. Drag that to the right as many columns as necessary.

 

[ActuaryTm]

Originally posted by: kreactor
instead of goin to cell b6 and type =B4/7.5 then c6 =c4/7.5 then d6, manually etc

how would i go about it so that it would automatically select the corresponding
column *4 value and dividing by 7.5, some sort of global column change function

Are you aware of the fact that in copying cells with any functions and formulas, the range(s) in said formulas and functions change dynamically dependent upon the destination cells? Also, as ArmenK alludes to, one can assign absolute cell references by both row and column (or both, simultaneously).

also is there such a function/formula so if condition a is true, then use this formula
i.e. if b2/3.3 > 4.4 then resultant value /3 and if condition b is true, value/2)

IF function, or nested IF functions.

 

[JW310]

See the little square in the bottom right-hand corner of the cell, when you click on the cell? Click on that square, and drag it down the column. It should automatically fill in the formula in each of the cells in the column. Alternatively, you can select a bunch of cells in the column, starting with the initial formula at the top, and then press Ctrl+D to fill down.

As for the second part of your question, look into the IF() function in Excel. That'll do what you want.

JW

 

[Zim Hosein]

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=242642&entercat=y

Good night Nik!

 

[Zim Hosein]

kreactor, have you looked here: http://office.microsoft.com/en-us/FX010858001033.aspx