Resetting a cell when value <0 to 5000

[Ian1976]

Hi folks,

I have a spreadsheet with a starting value in D4 (5000) and then in cell E4 (=D4-570) this continues across until it get to <0 is it possible to have a formula that would reset the cell to 5000 when it gets below 0?

5000

4430

3860

3290

2720

2150

1580

1010

440

-130

-700

The cell N4 (-700) i would like that to show 5000 again if possible?

Thanks

 

[Fluff]

How about

=IF(D4-570<0,$D4,D4-570)

 

[Ian1976]

lol, I should get you on speed dial! ???

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Ian1976]

Hi Fluff,

Would it be possible to reset the cell to any other specified number when it gets down to <0?

 

[Fluff]

Just change the $D4 to a cell with the value you want.

 

[Ian1976]

Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.