Need an Excel expert

[Nick1236]

I'm making a spread sheet for my work. I know how to multiply values in rows and display them in another row

ex) PRODUCT(E3;G3) / 60

I put that on column H and it displays my total run time in hours.

My question is how can I make it standard for the ENTIRE "H" column to display like this for each row? Right now I'm copying and pasting the above in each row and changing the numbers to the correct row

PRODUCT(E10;G10) / 60
PRODUCT(E13;G13) / 60
PRODUCT(E14;G14) / 60
PRODUCT(E16;G16) / 60
PRODUCT(E20;G20) / 60


I have a bunch of rows to do and this is very time consuming. Can I input something that would make "H" display the correct value for every row?

Thanks,
-Nick

[winnre]

Put the entry in the top H row you will use, then drag downward. Codes will increase with line numbers.

Or to verify, put proper entry in top 2 or 3 lines, enough for there to be a pattern, then highlight all, and then drag the dot in lower right down to bottom cell needed and code pattern will copy too.

[Nick1236]

Could you give me an example of the starting code? When I click and drag down it copies the same code into all the rows, giving the same value as row 2 (my start row)

[Nick1236]

nvm I got it to work.

New question, I have spaces in between rows, how can I make it so that it does not display anything in rows with no data? Right now its showing 0 in all the rows with no data?

[winnre]

Just highlight the 0 and press delete, and the code goes away from that cell.

[Nick1236]

That works too. I guess I'm asking if there is a way to have it display a value in column H only if there is data inputed into columns E and G on a row. This list is going to be updated and moved around daily so sometimes row 3 will have data and sometimes not (this applies for all rows 1,2,3,4,5,6,7.... etc)

[winnre]

You can always do a line of code, an empty line, a line of code, an empty line, etc, and then the spacing will copy down as well as the code. I prefer to do the code first and then pretty up the pages later.

[nubrun]

That works too. I guess I'm asking if there is a way to have it display a value in column H only if there is data inputed into columns E and G on a row. This list is going to be updated and moved around daily so sometimes row 3 will have data and sometimes not (this applies for all rows 1,2,3,4,5,6,7.... etc)

Try searching for conditional formatting.

Another way would be to use an if statement such as =if(h3="","", h3). I don't remember if "" counts as a blank, but I think so.

[Nick1236]

Ok. I thought maybe there was an "IF/THEN" command or something I could use.

If "E & G" = no input THEN display no value

If "E & G" = input THEN display calculated value

Something like that.

[Nick1236]

Try searching for conditional formatting.

Another way would be to use an if statement such as =if(h3="","", h3). I don't remember if "" counts as a blank, but I think so.

Yes exactly, something like this.

[rackem1899]

Ok. I thought maybe there was an "IF/THEN" command or something I could use.

If "E & G" = no input THEN display no value

If "E & G" = input THEN display calculated value

Something like that.

Yep, this is conditional formatting. Search for how to use it on your version of excel. You'll probably just want to make the font color the same as the cell color when = 0. and black when <.01 or something. Assuming you need the 0 to not show # on other codes.

[Nick1236]

Ok i figured it out thanks!

I simply made it display text as WHITE if value = 0

This way the value is there but I can not see it. Can I drag the formatting down the entire row like the calculation?

[Nick1236]

Got it working. Awesome.

Thank you for the help guys.