complicated formula

LaurisK

Hello, can you please help me solve this formula.

I don't understand what is wrong with it.

Mark.poole

@LaurisK

With out any further context into what it is your trying to accomplish I cant really say much as to what's wrong with it. from the outside looking in it looks correct. Based off of the if statement I can make these assumptions.

If Position change is blank, then check to see if end of employment is 1. "Im assuming this is a check box".If so then leave blank.

IF false, Check to see if User Sign is blank. If true leave the cell blank.

If false check Q12 Compleition to see if its blank.

If true then check the cell in employment 2 "not sure why this isn't at @row based on the screen shot",

If Employment 2 is Contractor, Show the cell Start Date 2

If false and employment 2 is Permanent show start date2. otherwise if this errors show a blank.

If Q12 Compleition isnot blank then show q12 compleition

If position change is not blank then show the cell posistion change 2.

Is all this correct?

heyjay

Your first arguement, =IF(ISBLANK([Position Change]@row needs to have an "IF True" arguement.

=
IF(ISBLANK([Position Change]@row,"Then Show This",
IF([End of Employement]@row = 1 ,"" , … … …    

same with the other isblank function. What do you want to happen / show if that cell ISBLANK?