I would like to round up a number that will give an answer 4 if less than for and the answer 5 if greater than 4 and 0 if greater than 5
I would like to round up a number that will give an answer 4 if less than for and the answer 5 if greater than 4 and 0 if greater than 5
=IF(REFERENCE<=4,4,IF(REFERENCE>5,0,5))
IF the reference is less than or equal to 4 than be 4, otherwise if it is greater than 5 be 0, otherwise just be 5 (As all that would be left is 4 through 5)
Corrections in BOLD good one Glenn - I am assuming the perfect 5 should be 5 so how it is written would have the desired or intended outcome.
Last edited by ELeGault; 11-29-2014 at 05:17 AM.
-If you think you are done, Start over - ELeGault
Only thing that just may be missing are what do you want to happen when the value is EXACTLY equal to four and five?? If you want them to be 4 & 5 - then the solution at #2 works perfectly.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I would like it to =4 if it's exactly4 and =5 if exactly 5
Then that is what is up above after it was modified - Glad it worked - Have a good one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks