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!
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!
Place into D4:Place this into E4:Please Login or Register to view this content.
Copy down.Please Login or Register to view this content.
Pete
Last edited by PeteABC123; 02-07-2020 at 04:41 PM.
Thanks Pete. All works. Was missing the B4>0 section. Thanks again!
Sorry Pete, if B4 is a negative # this doesn't work. Any suggestions? I've attached a sheet for your reference. Thanks
Last edited by wjmj; 02-07-2020 at 05:36 PM.
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.)
PetePlease Login or Register to view this content.
Last edited by PeteABC123; 02-07-2020 at 05:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks