I have built several sheets in numbers and with some of the inputs I get “The Formula uses a Boolean in place of a number”. This seems to occur when I get different information and the numbers change. I don’t always get the error message. Very difficult time wrapping my head around Boolean – One of the formulas is listed here. “IF (PPM::F5 <350,"200")+IF(PPM::F5<250,"200")+IF AND ((PPM::F5<350,PPM::J5<500),"200","100")
I am attempting to make recommendations for soil amendments, based on the numbers received from different clients' submitted soil samples (lab numbers) showing amounts of calcium, magnesium, phosphorus, and other nutrients. Depending on the numbers received from the lab, sometimes I get the error message, sometimes I don't.