|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 4th, 2006, 01:12 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple "if" formulas
Hello I'm new here and this may have been answered already, however I've been
unable to find the answer. I'm trying to have one cell (A1) give me a set number (10), if (B1=1) or (C1=2) or (D1=3) for example. Any help on this topic would be greatly appreciated. Let me know if there are any questions. Thanks, T_Sr 
|
|
#2
January 4th, 2006, 01:30 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Multiple "if" formulas
In A1:
=if(or(b1=1,c1=2,d1=3),10,"whatgoeshere") T_Sr wrote: Hello I'm new here and this may have been answered already, however I've been unable to find the answer. I'm trying to have one cell (A1) give me a set number (10), if (B1=1) or (C1=2) or (D1=3) for example. Any help on this topic would be greatly appreciated. Let me know if there are any questions. Thanks, T_Sr -- Dave Peterson
|
|
#3
January 4th, 2006, 01:35 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Multiple "if" formulas
=IF(OR(B1=1,C1=2,D1=3),10,"")
Vaya con Dios, Chuck, CABGx3 "T_Sr" u17260@uwe wrote in message news:59d463117080b@uwe... Hello I'm new here and this may have been answered already, however I've been unable to find the answer. I'm trying to have one cell (A1) give me a set number (10), if (B1=1) or (C1=2) or (D1=3) for example. Any help on this topic would be greatly appreciated. Let me know if there are any questions. Thanks, T_Sr
|
|
#4
January 4th, 2006, 01:39 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Multiple "if" formulas
this formula will do exactly what you suggest,look at the or and
functions..in A1 type =IF(OR(B1=1,C1=2,D1=3),10,"").So if any of tose conitions are true a1 will show 10 if ALL are false it wil be blank -- paul remove nospam for email addy! "T_Sr" wrote: Hello I'm new here and this may have been answered already, however I've been unable to find the answer. I'm trying to have one cell (A1) give me a set number (10), if (B1=1) or (C1=2) or (D1=3) for example. Any help on this topic would be greatly appreciated. Let me know if there are any questions. Thanks, T_Sr
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Countif formulas change after doing a sort | Bob Smith | Worksheet Functions | 3 | January 3rd, 2006 11:17 PM |
| apply cell names to formulas in multiple worksheets | BBurrows | Worksheet Functions | 4 | July 1st, 2005 05:35 PM |
| Using SumIF formulas with multiple lookup values | Chris Freeman | Worksheet Functions | 3 | April 13th, 2005 01:40 AM |
| Linking with multiple formulas | jwr | Links and Linking | 2 | April 11th, 2005 02:13 PM |
| Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
Linear Mode
