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 don't see a yellow column, but assuming that Ticket Amount is in A2 and down, and Nett price is in C2 and down, enter the formula =C2-A2 in B2, then fill down.
The costs don't appear to be consistent: for a ticket amount of 126, you have both 18 and 21 as costs.
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
That would look like
=IF(ticketprice=21;3;IF(ticketprice=42;6;IF(ticketprice=63;9)))
or
=IFS(ticketprice=21;3;ticketprice=42;6;ticketprice=63;9)
But it would become a very long formula. Besides, as I pointed out, your sample table has costs = 18 AND costs = 21 for ticketprice = 126...
