I need help
Please can someone help me devise and formula for the set of values below:
I am in need of a formula in Cell O4 for the following
100 in L4. 5 in N4. If L4 is less than or equal to 100 value to stay as N4. If L4 is greater than 100 but less than 500 O4 to show 80% of N4. If L4 is greater than 500 but less than 1000 O4 to show 60% of N4
Thanks in advance.
Johnny N Stars
Please read the forum rules and edit the title.
1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks