| 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. |
| 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 | |||
Threaded Mode
