Forum Discussion

anandprakashnm's avatar
anandprakashnm
Frequent Visitor
8 years ago
Solved

How to put condition for BLANK in IF

I have a senrio where i am Calculation in a diffrent manner:-

Course 1  Course 2  Course 2

Maths        Social       

Eng            Sanish    Social

Sci

 

I am trying to give code to Course 1 if they have taken maths as first course, 0 if blank and 100 if any other course

Course 1 num = If(Course1="maths",1,if(Course 1="Blank",0,100))

 

For Course 2

Course 2 Num = if(Course 2 = "Social",2,if(Course 2 = BLANK,0,100))

 

similarly for multiple courses. How we can set uprule for Blank?

 

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi anandprakashnm,

     

    You can try it like this.

    Course 1 num =
IF ( [Course1] = "maths", 1, IF ( ISBLANK ( [Course 1] ), 0, 100 ) )

    Best Regards,

    Dale

  • Aron_Moore's avatar
    Aron_Moore
    Icon for Solution Specialist rankSolution Specialist
    8 years ago

    I often use a column like:

     

    Open? = IF( [Closed Date] = BLANK() , "Open", BLANK() )

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi anandprakashnm,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale