|
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 |
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 |
| All times are GMT +1. The time now is 02:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com