Calling all math or Excell WIZards!

[ColmMcLoughlin]

Hi All!

Can anyone please help me. Im trying to record behavioural Data for a family I work with. I have half our Blocks along the top but these are broken up into 15 minute blocks Entering "1" = 15minutes and "2" = 30minutes.

The row that says "Doing Well" (Row 10) I want to count at 2 "Units" unless there is a value entered into the Obsessional Running or Obsessional Behaviour Rows. However I obviously dont want Row 10 to go into negitive figures as it would not make sense.

So in short I want the value in row 10 to count unless there is a value in Row 7 or 8.

So If K10=2 and K7=1, I want K10 to change to 1.

HOWEVER. If K10 = 2 and K7=2 & K8=2 I do not want K10=-2. (The minimium value of K10 has to be 0)

Been at this all day! Any help would be appreciated!

A NooB at excel would be calling me a Noob so any help is appreciated.

 

[ColmMcLoughlin]

Sorry, I ment to say. Im sure there would also be a formula to do it too but I dont have a clue where to start! Thanks again in advance!

 

[Hui]

Colm

Firstly, Welcome to the Chandoo.org Forums

You can use the Max() function to limit values less than 0 to zero
=MAX(your existing formula, 0)

However if you can explain what the logic is for each Row 7, 8 & 10 in plain English, then I'm sure we can give you a better solution

 

[NARAYANK991]

Hi Colm ,

I think you need to explain the following :

1. What values can K7 , K8 and K10 assume ? Just 1 or 2 , or are there more possibilities ?

2. If only the two values , 1 or 2 , are possible , then we can have several combinations :

K7 = 1 ; K8 = 1 ; K10 = 1
K7 = 1 ; K8 = 1 ; K10 = 2
.
.
.
K7 = 2 ; K8 = 2 ; K10 = 2

You need to say whether all the 8 possibilities are valid ; if not , which ones are invalid. For those that are valid , what should be the actual count that is to be considered for totalling purposes ?

Narayan