| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get a formula result in a "whatif" situation
I need to use a formula that will do the following:
Note: All entries are given numbers in compiling a survey. The following cells can be any combination of "1". A1=1 or A1=0 B1=1 or B1-0 I want C1 to return a 1 only if both A1 and B1 are 1. C1 should return a 0 in all other instances. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get a formula result in a "whatif" situation
in cell C1:
=IF(AND(A1=1,B1=1),1,0) "TG9522" wrote in message ... I need to use a formula that will do the following: Note: All entries are given numbers in compiling a survey. The following cells can be any combination of "1". A1=1 or A1=0 B1=1 or B1-0 I want C1 to return a 1 only if both A1 and B1 are 1. C1 should return a 0 in all other instances. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get a formula result in a "whatif" situation
=a1*b1 if values are 1 or 0
OR =If(and(a1=1,b1=1),1,0) "TG9522" wrote: I need to use a formula that will do the following: Note: All entries are given numbers in compiling a survey. The following cells can be any combination of "1". A1=1 or A1=0 B1=1 or B1-0 I want C1 to return a 1 only if both A1 and B1 are 1. C1 should return a 0 in all other instances. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
| Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
| How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Hybrid Mode
