| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple stipulations within the if
Hi- I want to have 3 or 4 different stipulations for an argument to be true. An Example: =if(2D-1D)-(1D-2E)1.99 AND (2B-2C)/2(2D-2C) Then the argument is true. I know how to do each individually, but need an example of performing both arguments in one cell. THANKS A LOT!! -- athalon ------------------------------------------------------------------------ athalon's Profile: http://www.excelforum.com/member.php...o&userid=31426 View this thread: http://www.excelforum.com/showthread...hreadid=511179 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple stipulations within the if
AND((2D-1D)-(1D-2E)1.99,(2B-2C)/2(2D-2C))
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "athalon" wrote in message ... Hi- I want to have 3 or 4 different stipulations for an argument to be true. An Example: =if(2D-1D)-(1D-2E)1.99 AND (2B-2C)/2(2D-2C) Then the argument is true. I know how to do each individually, but need an example of performing both arguments in one cell. THANKS A LOT!! -- athalon ------------------------------------------------------------------------ athalon's Profile: http://www.excelforum.com/member.php...o&userid=31426 View this thread: http://www.excelforum.com/showthread...hreadid=511179 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
| External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
| selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
