Hi everyone,
I hope I'm not repeating this issue I'm having. I would be very grateful if someone has a easy way to help me. I'm trying to make a scoring tool for a questionaire. Is there an easy and elegant formula to automaticly change the inserted numbers - all in one cell?
1 has to change to 3
2 has to change to 1
3 has to change to 0
Also:
0 => 0
1 => 0
2 => 1
3 => 2
Thank you so much for your help!
Relinqu
Last edited by relinqu; 01-24-2019 at 07:22 AM.
Not all in one cell, unless you use vba
A better option is to use extra columns to give the desired result the logic depends on if other values can exist in the cells and are ignored if(a1=1,3,if(a1=2,1, if a1=3,0,"")))
the >= bit of the post is also unclear and presumably is on different cells?
Yes, I also found my way around with more columns.
The => was ment as:
0 has to be 0
1 has to be 0
2 has to be 1
3 has to be 2
It's managable with more columns, but was wondering if there is a more elegant solution. Thank you for your help!
If your data are in A1:
=MAX(0,A1-1)
copied down
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks