Question: ```
=IF(SUM(B12-B10)<0,0,SUM(B12-B10))
=IF(SUM(B12-B10)>3270,3270,SUM(B12-B10))

```

I am trying to write an excel formula that will not allow the cell's value to go below 0 or above 3270. I have the two formulas above but I am not sure how to get them both into once cell. 

Does anyone know how to do this?

Answer: 
You put the second IF statement in the False of the First IF statement.

```
=IF(SUM(B12-B10)<0,0,IF(SUM(B12-B10)>3270,3270,SUM(B12-B10)))

```
This should work:

```
=IF(SUM(B12-B10)<0,0,IF(SUM(B12-B10)>3270,3270,SUM(B12-B10)))

```

Cheers