Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for multiple cells | Excel Worksheet Functions | |||
Formula for multiple cells | Excel Worksheet Functions | |||
Using one cells formula in multiple other cells | Excel Discussion (Misc queries) | |||
changing a formula in multiple cells | Excel Worksheet Functions | |||
Look up formula, multiple cells | Excel Discussion (Misc queries) |