How to put condition for BLANK in IF

[anandprakashnm]

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?

[v-jiascu-msft]

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

[Aron_Moore]

I often use a column like:

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

[v-jiascu-msft · Accepted solution]

Hi @anandprakashnm,

You can try it like this.

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

Best Regards,

Dale