Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging a formula
I have the formula below that T. Valko helped me with and it drags down the
columns fine but when I drag across it doesnt compute what I need. Perhaps I need absolue reference symbol in front of the letter instead of the number in each cell? Not sure really, I just know it makes me dizzy...Thanks for any help! -CRM =ROUND((MAX(0,MIN(D$10*(D$10<""),B55)-MAX(C$10,A55))+MAX(0,MIN(F$10*(F$10<""),B55)-MAX(E$10,A55))+MAX(0,MIN(H$10*(H$10<""),B55)-MAX(G$10,A55))+MAX(0,MIN(J$10*(J$10<""),B55)-MAX(I$10,A55)))/60*1440,2) -- -CRM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help dragging a formula down | Excel Discussion (Misc queries) | |||
dragging my formula | Excel Discussion (Misc queries) | |||
Dragging Down a Formula | Excel Worksheet Functions | |||
Dragging formula | Excel Discussion (Misc queries) | |||
dragging a formula | Excel Discussion (Misc queries) |