Newer to Numbers!!! It seems straight forward but I can not get it is work. If B2 has anything in it then I want E2 to have $1 auto fill. Next if anything is in D2 I want E2 to then have either $2 or $3 auto fill instead of the $1 depending on which pop up selection I made in C2 (Selection A or B). Can anyone help me with this, Please?
MacBook Pro 13", macOS 10.14
Hi J.
Your question has nothing to do with conditional formatting (currently called Conditional Highlighting.
Briefly put, conditional highlighting is about changing the style or colour foa type or the background if specifiic conditions are met. The rules compare the value in the cell to be formatted with a fixed value, written into the rule, or with the value in another cell in the same document. Your question asks about placing a specific value into a cell there is any content in another cell. That's not format.
To your question:
Your description of what you want is ambiguous.
You have three cells whose content or lack of content is to control the content of E2.
There are two possible states for each of three cells:
B can be empty or contain 'something'
D can be empty or contain something
C can contain A or B
2x2x2 gives a total eight possible states for the set of three cells, each with two possible states.
Here is a table showing the eight possible states of cell in the same row of those three columns. What is your expected result for column E in each row from 1 to 8?
Regards
,Barry
Hi JRAEBEL,
It might be helpful if your supply the big picture here. It is quite possible there are easier ways to get to what you want.
E1=IF(LEN(D1)>0,IF(C1="A",2,3),IF(LEN(B1)>0,1,0))
I think this covers what you asked for. 3 nested IFs are about the most you want to use.
quinn
Thank you Quinn I was able to get it worked out with this information. Thank you
The only other thing I have is, if I put something in B,C or D and thus get a value in E if I delete B,C and D the value remains in E. How do I get it to go back to zero or blank either would work?
Hi JRAEBEL,
Glad that worked for you. The key with nested IFs is figuring out where to start. It is not always the first place we consider.
quinn
Disregard I got it.
👍
I see that now. Before Long I will zip through Numbers like a pro, again thank you so much
This forum has been a great resource for me. Learned stuff I didn't thinkto ask.
q
Hi JRAEBEL,
Your table should recalculate whenever you make a change to it.
The LEN() formula counts how many characters are in the target cells so if there is any entry, even a <space> it will return True. Try a single click in the cell and delete.
quinn
Conditional Formating
