Simple Excel Help

[korme]

I know I've done this before but for some reason I cannot search correctly for this. I want to fill the rest of this table out with simple W/L records with a (x-x) total at the bottom. Formula is on the screen, what am I doing wrong?

[CarterNMA]

Change the commas to the left and right of "-" to ampersands?

[Vince, Pt. II]

That will work. Or wrap the whole thing in a concatenate().

[Vince, Pt. II]

Either of these:
=countif(c4:c15,"W")&"-"&countif(c4:c15,"L")

=concatenate(countif(c4:c15,"W"),"-",countif(c4:c15,"L"))

[korme]

So simple. Thanks guys.

[korme]

Is there a way to add a row in the future and have that formula auto-update? This will be a yearly updating obviously so I envision a lot of tediousness here.

[henry296]

you can use offset at end of the range used in the countif.

Countif(c4:offset(c16,-1,0)

The offset says start in c16 and go up 1 row and over 0 columns. Since the c16 is a relative reference it will change when you insert the row.

[korme]

Thanks, huge time saver.

[Jan135]

Hello! Sorry for potentially unrelated question, but are there any major differences between Microsoft Excel and Google Sheets? I am starting a secretary job at a new place and they insist on me using Google Sheets instead of Excel. From the first look, it looks the same, but you can never know.

[flere-imsaho]

I've had to use Sheets a bit in the past few years and I'd say they're reasonably close. I still prefer Excel as it feels more responsive and I'm used to Excel's formula names vs. Sheets' formula names (they both have most of the same formulas, just different names).

Sheets' major disadvantage vs. Excel is when you're working with a lot of data (e.g. over 1000 rows). You need to add rows manually after 1000, and it slows way the fuck down, especially if you're going to do analysis on that much data.

[Mike Lowe]

Is it ok to threadjack this? Actually seems to be a good idea for a general Excel help thread:

I am simply trying to rotate a sunburst graph. There doesn't seem to be anyway to actually rotate this. At default, it has a vertical line for 50% and I want it to instead be horizontal. It's a dynamic graph too, so I can't just do the trick of using an actual image in the background of a graph.

You used to be able to do this with the donut graph in older Excel.

[flere-imsaho]

Sorry, no idea. All graphs in Excel seem to exist solely to frustrate me.

[Mike Lowe]

Giving this a bump with a question that's probably easy for you Sheets/Excel experts:

I have the following that works fine:
=IF(C9>20000,C3*1.1,IF(C9>10000,C3*1.05,IF(C9>50000,C3*0.95,IF(C9>0,C3*0.9,"Enter Mileage Below"))))

What I'm trying to add within this is a simple addition of a number after this all generates. So for instance, if "2022" is found in B1, I want to add the number 5,000 at the end of the expression above. Add 10,000 for 2021, etc.

Hope this makes sense! I'm basically not sure how to add a second nested IF statement into the same cell. I'm hoping I can have this perform an additional task (add the number based on an entry in B1) to the end of this existing statement.

[MIJB#19]

Originally Posted by Mike Lowe

Giving this a bump with a question that's probably easy for you Sheets/Excel experts:

I have the following that works fine:
=IF(C9>20000,C3*1.1,IF(C9>10000,C3*1.05,IF(C9>50000,C3*0.95,IF(C9>0,C3*0.9,"Enter Mileage Below"))))

What I'm trying to add within this is a simple addition of a number after this all generates. So for instance, if "2022" is found in B1, I want to add the number 5,000 at the end of the expression above. Add 10,000 for 2021, etc.

Hope this makes sense! I'm basically not sure how to add a second nested IF statement into the same cell. I'm hoping I can have this perform an additional task (add the number based on an entry in B1) to the end of this existing statement.

If I'm getting you correctly, I'd say your options are:
= IF(the big if with C9 and C3) + IF(B1 = 2022,5000,if(b1 = 2021, 10000, etc))
This only works if both your if-statements will always result in numbers, or it could give some errors.

If the "Enter Mileage Below" text is your safety net for values <= 0, then I'd suggest you:
= IF(C9 <= 0 , "text", if(c9> 20000, etc ) + if(B1 = 2022,5000,etc ) )


For the IF(B1 = ) part, you might want to consider a VLOOKUP pointing to a table that has the values 2022 and 5,000 together, and has 2021 and 10,000 together, etc. It's trickier for the IF(C9 = ) part, because you're using ranges.

[Mike Lowe]

This worked great and was so easy! Thank you so much!