Why does this not work?
Posted by Cliff Myers on August 04, 2000 8:59 PM
In a purchase journal I want to issue a warning when an account has exceded its budget. Cells j42:o42 shows the remaining amount in each account. Cells f9:f38 are where we enter the account number. The formula I used is =if(and(j42:O42=0, f9:f38=610, f9:f38=612, f9:f38=613, f9:f38=617, f9:f38=624, f9:f38=625, f9:f38=614), f9:f38). This formula works when the account reaches $0 but the problem is, it also displays the warning when the account number is entered and the account is still positive. Where have I errored in the above formula?