Nested if question

[taffmorgan7274]

Good day. I am trying to put a nested if formula together which is dependent on various criteria. I want a formula which will show -350 in cell c5 if cell c2 is over 1000. I want the same cell to show -250 if cell c2 is less than 1000 but I want it to show 0 if there is no value in cell c2. Any Assistance would be greatly appreciated.

 

[Peter_SSs]

will show -350 in cell c5 if cell c2 is over 1000. I want the same cell to show -250 if cell c2 is less than 1000

What do you want the formula to show if C2 is exactly equal to 1000?

 

[taffmorgan7274]

I would like the first part of the formula to show -350 if it was exactly a 1000. I would like it to show -250 if it was more than 1 and less than 1000 and I would like it to show 0 if it equaled 0.

Thank you.

 

[Peter_SSs]

show 0 if there is no value in cell c2.

show 0 if it equaled 0

The two highlighted part are not identical so the requirement is not entirely clear. However, see if this is it

=IF(C2="",0,IF(C2<1000,-250,-350))