can this be done?

[Hoffman]

Hi

I have a cell that reads the student's average from another cell. I use =$B$70 and the average from the B70 cell appears here.

Is there a way to have TEXT and this dynamic average appear in the same cell so the student name and THEIR average (which changes depending on how B70 changes) would appear in the same cell? ex John Smith 95 all in one cell.

Thanks

Barry

 

[Ramballah]

Well this is just me doing it on a harder way. im pretty sure there is an easier way but here goes:
You could use an IF formula. If there is a set date you can do this:

Now its just an if formula
=IF(TODAY()<31-12-2018;"donaldduck!a1&" "&text(donaldduck!b1,"0%")";"mickeymouse!a1&" "&text(mickeymouse!b1,"0%")") and just autofill it

 

[Hoffman]

Well this is just me doing it on a harder way. im pretty sure there is an easier way but here goes:
You could use an IF formula. If there is a set date you can do this:

Now its just an if formula
=IF(TODAY()<31-12-2018;"donaldduck!a1&" "&text(donaldduck!b1,"0%")";"mickeymouse!a1&" "&text(mickeymouse!b1,"0%")") and just autofill it

Thanks.

there is no set date so I will just have to do by hand but that looks very interesting!

Barry

 

[Ramballah]

Thanks.

there is no set date so I will just have to do by hand but that looks very interesting!

Barry

Alright. Well there is probably a way but i just don't know it. Oh well. Goodluck!

 

[JazzSP8]

What if I set this up exactly with 108 students on sheet 10 all looking at Sheet 1, but then in 2 months I need all those same 108 student cells to look at sheet 2 (new quarter in school), is there any easier way besides going thru 108 cells and changing the reference sheet?

Unless I'm missing something you can just use "Find and Replace"

Find Sheet1! Replace with Sheet2!

 

[Hoffman]

Unless I'm missing something you can just use "Find and Replace"

Find Sheet1! Replace with Sheet2!

thanks, never knew about that!

Barry

 

[Ramballah]

neither did i lol