Percentage reduction formula help !!
So am making a spreadsheet for ICT coursework ( A level) and am trying to use a multiple if statement where you input you yearly salary and it minuses of tax, based upon UK tax allowance but its not doing anything?
Any help would be great thanks
dfsadfs.PNG
Your last IF statement hasnt got an action for IF FALSE.
If someone has helped you then please add to their Reputation
What do you mean??
Sorry not great at Excel, could you type it up if thats alright?
Thanks
Try
D4=ROUND(VLOOKUP(SUM(D2:D3),{833,100;3532,80;12500,55},2)*SUM(D2:D3)/100,2)
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
basically, you're using a Nested IF without a final option, what you need is
You're missing the statement that goes where the FALSE is. Currently your code doesnt take into account values > 12500
Please Login or Register to view this content.
Thanks alot guys managed to fix it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks