• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If statement question

H

HVK1986

New Member
Hi all,

I have a prob in IF formula.

I have a data in cell A1. I have data validated the values in cell B1.

eg, i have a question in cell a1 as 1+2=? the values in drop down list in B1 are 2,3,4.

now i have 2 problems.


1) the arrow mark of the data validated cell should always be seen, irrespective of the cursor is clicked on ot or not.


2) i have used a if function in cell c1 which displays the ans.'

if b1 is selected as 3, then it should display "correct ans" in c1, if nothing is selected in b1,nothing should be displayed in c1.


Pls guide.
 
Harry


Debra Dagleish over at the Contextures Blog has a great collection of posts on Data Validation

Refer to: http://www.contextures.com/xlDataVal01.html

and the links at the bottom of the post to other posts
 
1) I personally dont know how/if this is possble. I slightly question it being possible due to the fact that when the drop down arrow does show up, it is always overlapping the adjacent cell on the right, thus covering up part of the content of that cell (depending on width and length of content of said cell)... however, i'm not even 50% on this..... just wondering


2)=IF(b1=3,"Correct Ans","")

note: if this applies to other cells with different 'correct answers', you'll have to get more creative. (hidden column with the 'correct answer' value perhaps)
 
You must log in or register to reply here.
Back
Top