Forum Discussion
IF formulas
I'll jump in just to suggest that if that sample you gave is representative, then you need the IFS function, as in
=IFS(ticketprice=21,3,ticketprice=42,6,ticketprice=63,9.....)
but I'll also offer that (at least given what you've shown) you could also just say
=ticketprice/7
which leads me to ask "What is this really doing?" What is the mathematical relationship between the columns on each row, and possibly even between successive rows?"
https://exceljet.net/excel-functions/excel-ifs-function
I'll jump in just to suggest that if that sample you gave is representative, then you need the IFS function, as in
=IFS(ticketprice=21,3,ticketprice=42,6,ticketprice=63,9.....)
but I'll also offer that (at least given what you've shown) you could also just say
=ticketprice/7
which leads me to ask "What is this really doing?" What is the mathematical relationship between the columns on each row, and possibly even between successive rows?"
https://exceljet.net/excel-functions/excel-ifs-function
If you example is correct Ticket Amount 126 could have two different costs, logic which one to select is not defined
- Thanks for your observation. The lower cost amount is incorrect in this example. In the meantime I've found the solution by using the IFS function.
