Forum Discussion
If function
Hi. I've got the following test, that I really need help with. I have the following data: 1 Point: 20 Euros to 3 pages: 0,5 above 3 pages: 0,3 name surname pages pay Naomi Evans 4 ...
Natalija80 No need for a file. Your question is clear. No need for IF or SUM either. You can achieve your goal by using MIN and MAX. The attached fie demonstrates this in, though, in a simplified way. But perhaps you find it helpful.
Thank you!!! But the point of the homework I was given was to use the “If” functions...Finally I found the solution =IF(D9<=3;D9*0,5;IF(D9>3;1,5+$C$6))*20. Half a day and a lot of stress 😂😂😂 but I am still really thankfull for your help. Its interesting to know how many ways there are to come to the solution ☺️
Natalija80 Fair enough. Personally, I tend to avoid nested IF functions if I can. Good you figured it out yourself.