Simple what if formula

[wjmj]

Hello all, I'm having brain cramps. Just a simple question. Looking to populate a cell if another cell has a value. Please see attached sample sheet that has notes to explain. Thanks in advance!

[PeteABC123]

Place into D4:

Please Login or Register  to view this content.

Place this into E4:

Please Login or Register  to view this content.

Copy down.

Pete

[wjmj]

Thanks Pete. All works. Was missing the B4>0 section. Thanks again!

[wjmj]

Sorry Pete, if B4 is a negative # this doesn't work. Any suggestions? I've attached a sheet for your reference. Thanks

[PeteABC123]

Jim: Place this into D4 to correct an error if profit is a negative. (They should revisit their margins and cost models if this is continually problematic.)

Please Login or Register  to view this content.

Pete