I need to be able to say in a cell "If the amount in B4 is over 800 dollars the customer gets 10% discount so cell B5 will show 10% or if the amount is over 1000 they get a 15% discount, or if its over 2000 dollars they get a 20% discount" I swear every time I try to get this to work I get an error. Can someone tell me what the formula would be for this? I know I am missing something just can't figure out what I am doing wrong.
I just have a basic spreadsheet that I am trying to help my uncle with and this is driving me nuts! lol
Thanks People! Its been awhile since I have posted to here but you guys/gals are the greatest!
EDIT: I just need the cell to show "10%" not actual show what 10% would be...hope that helps
I just have a basic spreadsheet that I am trying to help my uncle with and this is driving me nuts! lol
Thanks People! Its been awhile since I have posted to here but you guys/gals are the greatest!
EDIT: I just need the cell to show "10%" not actual show what 10% would be...hope that helps
Last edited: