Hello,
I have this kind of formula :
IF(A1=0;VALUE 1;IF(A1=1;VALUE 2;XXX)) and I would like that XXX (the ELSE condition) should maintain the previous current value, if A1 <> 0 or 1 :
- VALUE 1 if in the previous test, A1 was 0
- VALUE 2 if in the previous test, A1 was 1
Hope my question is clear.
Thanks for the kind help in advance.
Frederic
Then you will need this:
=IF(A1=0;VALUE 1;IF(A1=1;VALUE 2;A1))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Formula:
Please Login or Register to view this content.
For example
if the previous value = 5
Formula:Please Login or Register to view this content.
If previous formula was =A2+A3 then
Formula:Please Login or Register to view this content.
Hi,
First I thought that, as AliGW wrote:
=IF(A1=0,VALUE 1,IF(A1=1,VALUE 2,A1))
is what you look for, but then I started wondering what do you mean by "previous current value".
Let's say this formula is in B1, and we have the following sequence:
First you write 1 in A1 so B1 becomes VALUE 2
Then you write 0 in A1, so B1 becomes VALUE 1
And then you write 3 in A1 so B1 "recognizes" it's neither 0 nor 1 and remais unchanged as VALUE 1
If it's what you look for, then I'd rather see not formula in B1, but macro (event handler for Change event) reacting to changes in A1.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks