for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

larkim Nov 2024 12:44pm, 18 Nov 2024 26,137 posts	Quote Pin 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	Quote Pin Diogenes Excellent, I knew someone clever would have the answer to this.
um Nov 2024 1:02pm, 18 Nov 2024 9,049 posts	Quote Pin 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	Quote Pin 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	Quote Pin 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	Quote Pin 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	Quote Pin 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	Quote Pin 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
lammo 13 Feb 11:08am, 13 Feb 2025 12,961 posts	Quote Pin lammo Morning all, happy new year Does anybody have a ready to go formula for working out actual payments of various mortgage rates and various fees? I feel it's going to take me a while to sort out. Thanks
GlennR 13 Feb 11:20am, 13 Feb 2025 77,405 posts	Quote Pin GlennR This might help lammo: moneysavingexpert.com