Please help, this is quite urgent and just cant seem to figure it out.
I need the number of Days returning when i enter in an amount for example
£1500 = 5 Days.
The full list is below
£1-£1000 = 3 Days
£1001-£2500 = 5 Days
£2501-£5000 = 10 Days
£5001-£9999 = 20 Days
£10,000 + = 30 Days
I managed to get so far with the following formula but something is wrong with it and now im stuck.
=IF(A2>10000,"30 Days",IF(A2>5000,"20 Days",IF(A2>2500,"10 Days",IF(A2>1000,"5 Days",A2>1"3 Days"))))
Please help thanks
Lee
Bookmarks