INVALID COLUMN VALUE Error

CaraBart28

Hello,

I am receiving the invalid column value error. If the referenced cell contains either standard cuff or is blank it should return a blank value, however I am getting an error with the formula I am using, please see below:

bisaacs

Hey @CaraBart28,

I think you need to wrap false in quotes, that should fix it!

Mark.poole

@CaraBart28

=If([Blood Pressure Cuff Size]@row = "Extra Large Cuff (>16.5 in.)","Extra Large Cuff (>16.5 in - 18.5)", If(Or([Blood Pressure Cuff Size]@row ="Standard Cuff (<16.5 in.)",[Blood Pressure Cuff Size]@row=""),""))

CaraBart28

@Mark.poole

I tried the formula you provided and I am receiving the invalid data type error, I corrected the spelling and syntax but still receiving the error.

IF([Blood Pressure Cuff Size]@row = "Extra Large Cuff (>16.5 in.)", "Extra Large Cuff", IF(OR([Blood Pressure Cuff Size]@row = "Standard Cuff (<16.5 in.)", "", [Blood Pressure Cuff Size]@row = ""), ""))

Mark.poole

@CaraBart28

The Or statement works like this. IF(or(logical expression 1,Logical expression 2,…..)

Thus you wont need the extra "" that I bolded. between IF(OR([Blood Pressure Cuff Size]@row = "Standard Cuff (<16.5 in.)", "", [Blood Pressure Cuff Size]@row = ""), ""))

Did the original Formula not work?

a longer one to achieve the same idea would be

=IF([Blood Pressure Cuff Size]@row ="","",IF([Blood Pressure Cuff Size]@row = "Standard Cuff (<16.5 in.)","",IF([Blood Pressure Cuff Size]@row = "Extra Large Cuff (>16.5 in.)", "Extra Large Cuff")))