If Blank formula help

ldavenportHAP

=IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down"))

I want to add if "Accounts Per Day w/o TOOQL" @ Row is blank, leave blank or sideways arrow is fine if i have to choose something.

Mike TV

@ldavenportHAP

Sorry, here's the working one:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down", "")))

Mike TV

@ldavenportHAP

Try this:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down"), ""))

ldavenportHAP

@Mike TV

i am getting incorrect augment set with this..

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row), "", =IF(OR(Level@row = "", [Accounts Per Day w TOOQL]@row = ""), "", IF([Accounts Per Day w TOOQL]@row < Level@row, "No", "Yes"))))

Mike TV

@ldavenportHAP

Try this:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down"), ""))

ldavenportHAP

@Mike TV i am still getting "This column formula syntax isn't quite right" with that :(

Mike TV

@ldavenportHAP

Sorry, here's the working one:

=IF(NOT(ISBLANK([Accounts Per Day w/o TOOQL]@row)), IF([Accounts Per Day w/o TOOQL]170 < [Accounts Per Day w/o TOOQL]@row, "Up", IF([Accounts Per Day w/o TOOQL]170 > [Accounts Per Day w/o TOOQL]@row, "Down", "")))

ldavenportHAP

@Mike TV Thank you!!