Multiple stipulations within the if

  • Thread starter Thread starter athalon
  • Start date Start date
A

athalon

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!!
 
AND((2D-1D)-(1D-2E)>1.99,(2B-2C)/2>(2D-2C))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF/SUMIF comparing two rows of data 3
PR_RTF_COMPRESSED open failed 0
finding, sorting, put only part of a cell 4
how can i check for #Value! ? ... or how do I do MaxIf?? 1
how can i count multiple variables in multiple columns? 1
Redimming 2D array to 1D while preserving the data? 8
RADIO BUTTON LINKS SWITCHING BACK TO NUMBER 1
Export CSV dash is \226 (unicode) 3

Back
Top