Help with an IF Formula
Hello and help,
I need a formula to add $10.00 if cell A1 is <100, if A1 is between 100.01 - 500 then add $15.00, if between 500.01 -1600 then add $35.00, if between 1600.01 - 5000 then add $55.00, if between 5000.01 - 10,000 then add $65.00, if between 10,000.01 - 15,000 then add $85.00, if greater than $15,000 then add $2.00 for each additional $1,000.
Capture.PNG
With your value in A1, set up a table (like you have except just input the minimum values instead of range, i.e. 0,100.01, 500.01, ...) in G1:H6.
Your formula would be
Formula:
Please Login or Register to view this content.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
What would the rest of the formula be? I have set up my range but I need to complete the formula.
=VLOOKUP(W29, $ac$29:$ad$34),2,?????
Last edited by ShawnaRhode; 03-19-2020 at 01:08 PM.
Sorry, I left out an argument. It would be
=VLOOKUP(W29, $ac$29:$ad$34,2)
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks