Forum Discussion

tmadaras's avatar
tmadaras
Copper Contributor
Sep 30, 2021

Excel IF/AND/OR formula support

I have 2 formulas that I need help with - For this first formula, I cannot get the field to give me data for all names and levels it ONLY gives me data for all levels of Bronze but not the others.  ...
excel
Formulas and Functions
tmadaras's avatar
tmadaras
Copper Contributor
Sep 30, 2021
mathetes - I am definitely open to rethinking the spreadsheet - I am a novice at Excel and I am learning. I do like the suggestion - do you have an example of what you are suggesting I could look at and I will take a stab at it. Thank you.
mathetes's avatar
mathetes
Silver Contributor
Sep 30, 2021

tmadaras 

 

I've attached an example created simply as a demonstration--it does use the LET function which is very new, so you'll need to have the most recent version of Excel to make it work. If it doesn't work for you, please let me know and I'll find another example.

 

This example calculates US income tax, and is somewhat comparable to your situation in that I actually have multiple tables underneath the central formula--one table for each of the different tax filing statuses possible--and all it is doing is a single calculation based on a single input, but it uses the VLOOKUP function to access the appropriate row of the appropriate table.

 

Beyond that, or maybe BEFORE that, since you are a beginner in Excel, it might be helpful if first you just look at a basic primer on tables and VLOOKUP. Here are some links that could be helpful in that foundational learning: 

Tables: https://exceljet.net/excel-tables

VLOOKUP: https://exceljet.net/excel-functions/excel-vlookup-function

 

Resources