L
lee bexton
Please help, im trying to get excel to return a number if the amount entered falls between 2 set amounts. Example below.
?1-?1000 3 Days
?1001-?2500 5 Days
?2501-?5000 10 Days
?5001-?9999 20 Days
?10,000 + 30 Days
So if an amount is entered, say ?4500 it would return 10 Days.
I managed to get a formula kind of working but it doesnt seem to work all the time.
=IF(A2>10000,"30 Days",IF(A2>5000,"20 Days",IF(A2>2500,"10 Days",IF(A2>1000,"5 Days"))))
Can someone please help as this is quite urgent.
thanks
Lee
EggHeadCafe - Software Developer Portal of Choice
EBCDIC Encoding with .NET
http://www.eggheadcafe.com/tutorial...35-0e2a7d65f615/ebcdic-encoding-with-net.aspx
?1-?1000 3 Days
?1001-?2500 5 Days
?2501-?5000 10 Days
?5001-?9999 20 Days
?10,000 + 30 Days
So if an amount is entered, say ?4500 it would return 10 Days.
I managed to get a formula kind of working but it doesnt seem to work all the time.
=IF(A2>10000,"30 Days",IF(A2>5000,"20 Days",IF(A2>2500,"10 Days",IF(A2>1000,"5 Days"))))
Can someone please help as this is quite urgent.
thanks
Lee
EggHeadCafe - Software Developer Portal of Choice
EBCDIC Encoding with .NET
http://www.eggheadcafe.com/tutorial...35-0e2a7d65f615/ebcdic-encoding-with-net.aspx