If then formula with multiple cells
Hi there,
I have columns D and E either containing numbers of are blank. I want a formula in cell F to output the following:
a) if both columns D and E contain a number, I want it to output "both paid"
b) if column D contains a number but E does not, I want it to output "conference pmt pending"
c) if column E contains a number and D does not, I want it to output "membership pmt pending"
I have no idea how to enter an IF formula with that many variables. Thoughts?
|