SpreadEveryone: The Fetchland Excel wire

101 watchers

larkim Nov 2024 12:44pm, 18 Nov 2024 26,137 posts	0 larkim You could nest it as =LET(vTotal,SUM(E2:I2),IF(vTotal=0,"TT"," "))
Diogenes Nov 2024 12:55pm, 18 Nov 2024 89,391 posts	0 Diogenes Excellent, I knew someone clever would have the answer to this.
um Nov 2024 1:02pm, 18 Nov 2024 9,049 posts	0 um GordonG wrote: If I was to really push my ask, I’d like cell I2 to simply display the letters TT if the number is 5 or above and to display nothing if it’s 4 or below, but that’s less of a concern than just simply having the calculations automated. So what you really want, ignoring all that month stuff, is "If cells D2 to H2 are blank, set I2 to TT" ? That's a lot easier than counting blanks or shuffling months and numbers. Or have I misunderstood? eg In = IF(ISBLANK(Dn:Hn),"TT","")
GordonG Nov 2024 1:29pm, 18 Nov 2024 10,712 posts	0 GordonG @um yes. Not only have you figured out the answer, it looks like you figured out the question too!! Thanks, and again to everyone else for their help and input.
GordonG Nov 2024 2:29pm, 18 Nov 2024 10,713 posts	0 GordonG [quick update: i couldn't quite get ISBLANK to work, but it works with =IF(COUNT(A3:E3)>0,"","TT") ] thanks again everyone
GordonG Nov 2024 2:36pm, 18 Nov 2024 10,714 posts	0 GordonG [and by adding a 1 in each column every month someone runs, i should have added]
3M Nov 2024 4:09pm, 18 Nov 2024 25,160 posts	0 3M GordonG wrote:@um yes. Not only have you figured out the answer, it looks like you figured out the question too!! Thanks, and again to everyone else for their help and input. 2/3 of being a good programmer/developer is asking the question in it's most simple form!
larkim Nov 2024 11:34am, 19 Nov 2024 26,140 posts	0 larkim Not entirely an excel question, but more a maths one. If I have a range of data points that broadly span the range -2 to 2 for a performance measure, and I want to calculate a weighted average of those based on an additional (fully related) factor, is it correct to do "normal" weighted average calcs - i.e. sumproduct(Range_A,Range_B)/sum(Range_B) e.g. Score Size Body 1 -0.2 300 Body 2 -0.4 100 Body 3 +1.2 50 Body 4 -0.1 500