WHAT IF question

[Tplongy]

Hi there

Am new to the forum and am not sure if I am therefore posting this in the correct place, hopefully someone will tell me if not!
I am totally new to the "What if" formula. I have read various examples online, but have to admit am flummoxed and wonder if anyone can help.
I am doing a cashflow forecast. What I want is for my cell (E13) to look at Cell D25, and only insert a value into E13 if the cell D25 is a NEGATIVE value, otherwise cell E13 to remain at zero.

Could anybody please help with out?

Many many thanks

 

[Joe4]

Welcome to the Board!

You did not specify what value you want to insert, or where it is coming from, but your formula in cell E13would look something like this:

=IF(D25<0,x,0)

where "x" is the number you want to insert.

 

[Tplongy]

Hi Joe4
Thank you speedy answer, but appreciated. If for example the value in cell D25 is -2500 then I would want cell E13 to insert that value.
If the value in D25 is a positive value, ie 2500, then I would want cell E13 to say zero/0.
Is this what you needed?

 

[Joe4]

OK, just do what I said and replace the "x" with D25 (it was not clear what number you wanted to return), i.e.

=IF(D25<0,D25,0)

But if this is what you really want to do, you can use an even simpler formula:

=MIN(D25,0)

 

[Tplongy]

Perfect, works like a dream!! Its amazing how simple things are when you know what you are doing.
Many thanks, much appreciated.

 

[Joe4]

You are welcome.
Glad I was able to help!