Forum Discussion
Solved
IF formulas
Hi, I'm looking for the right formula in the yellow column to automatically calculate the cost in stead of manual input Ticket Amount costs Nett ticket price insert which formula IF func...
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.