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
HansVogelaar
Thanks Hans. What I'm looking for is an IF formula which says e.g. =IF(ticketprice=21;3),IF(ticketprice=42;6), IF(ticket-rice=63;9),.........etc.
I've tried this, but the result is "VALUE"
What is a correct IF formula for this solution?
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.
