If a certain cell ( E29 for example ) contains a number between 0 and 5, I want the cell I'm programming to fill with CL1, however if E29 contains a number between 6 and 10 I want the cell I'm programming to fill with CL2, if E29 contains a number between 11 and 20, CL3 and up to CL7 - Please give me the exact formula at least up to CL2 - THANK U!!
Also posted here.
http://www.excelforum.com/excel-new-...mula-help.html
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks