Team,
I have a big issue/need to complete a DB by AM Thursday. Would someone be able to help me with this IFS statement and why it returns #name .
IFS(F5=0, 150,F5<=1, (1-F5)/1*25+125,F5<=3, (3-F5)/2*25+100,F5<=5, (5-F5)/2*50+50,F5>5,0)
When I recieved the Formula it was like this...