more help - Formula to check values

  • Thread starter Thread starter milehigh
  • Start date Start date
M

milehigh

maybe someone can help - I am dealing with a negative
numbers:

if the value in cell 1 = -1.0 and lower (i.e. -2.0)
then "CR" should display in cell 3

If the value in cell 1 = .99 through .30 then "PR" should
display in cell 3

If the value in cell 1 = .29 through .21 then "SD" should
display in cell 3

If the value in cell 1 = .20 and higher or if cell 2
= "yes" then "PD" should display in cell 3.

As an FYI - I am creating a spreadsheet to track cancer
tumor measurements - the value in cell one is a
percentage of change from the baseline measurements.

Thanks again - this is driving me crazy......
 
What happens between .2 and =1, and what happens if cell 1 =.2 and higher,
but cell 2 does not = "yes".

And if cell 1 is higher than .2 and cell 2 = "yes", does this override the
statement that cell 1 = .29 thru .21 then "SD"?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top