• 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.

Please help me for excel formula to our Dashboard.

S

sampath

Member
Hello,

I have an production tracking dashboard, In that dashboard,

When i entered C1 in A1 cell automatically B1 will reflect 5
if C2 in A1 cell, B1 get 6
if C3 in A1 cell, B1 get 8
if C4 in A1 cell, B1 get 10.

I am using below mentioned formula but can't get the output in B1 cell.

=IF(AND(A1="C4"),"10",IF(AND(A1="C3"),"8",IF(AND(A1="C2"),"6",IF(AND(AH="C1"),"5",IF(AND(AH="")," "))))).

Kindly clarify this concern.

Regards,
Sampath.S
 
Hi Sampath ,

The AND function needs to be used only if there is more than one test ; since you are checking for only one value at a time , dispense with all the AND functions :

=IF(A1="C4",10,IF(A1="C3",8,IF(A1="C2",6,IF(AH="C1",5,IF(AH="","","Invalid")))))

Narayan
 
You must log in or register to reply here.
Back
Top