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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formula with multiple cells
hi,
Am Fri, 13 Sep 2013 00:59:57 +0100 schrieb Ada33: 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" try: =IF(COUNT(D1:E1)=2,"both paid",IF(ISNUMBER(D1),"conference pmt pending","membership pmt pending")) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
|
|||
|
|||
You are a genius sir! Thank-you! :)
Quote:
|
Reply |
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) |