June 6, 200520 yr Newbies I am trying to create a formula using the and operator and the IF function. I would like the formula to state something like this: IF(RBC Mass>36,and IF(WBC Count>92,and IF(Blastophil= "Yes","Positive for Polycythemia Vera","Not Available"))). Can this be done in Filemaker Pro?
June 6, 200520 yr If(RBC Mass>36 and WBC Count>92 and Blastophil = "Yes","Positive for Polycythemia Vera", "Not Available")
June 8, 200520 yr Author Newbies sbg2, Thanks for your prompt response re "and operator" post. Works like a charm. I have many uses for this. RAHutch
Create an account or sign in to comment