B bpflyr Board Regular Joined Nov 7, 2005 Messages 116 Dec 1, 2005 #1 I know I'm close to a formula, but I just keep getting stuck. Here's what I'm trying to do in one formula: IF J138 is blank (no data), then return E138 IF LEN(J138)>0, then return SUM(E138-J138) Otherwise be blank. Thank you!
I know I'm close to a formula, but I just keep getting stuck. Here's what I'm trying to do in one formula: IF J138 is blank (no data), then return E138 IF LEN(J138)>0, then return SUM(E138-J138) Otherwise be blank. Thank you!
Norie Well-known Member Joined Apr 28, 2004 Messages 76,061 Office Version 365 Platform Windows Dec 1, 2005 #2 Try this =IF(LEN(J138)>0, E138-J138, E138)
B bpflyr Board Regular Joined Nov 7, 2005 Messages 116 Dec 1, 2005 #3 Thank you, that works, but I need to add...(this formula is going into cell K138) IF the formula does do the calculation E138-J138, then K138, needs to be blank, otherwise, like you wrote, return E138. Thanks.
Thank you, that works, but I need to add...(this formula is going into cell K138) IF the formula does do the calculation E138-J138, then K138, needs to be blank, otherwise, like you wrote, return E138. Thanks.
Y Yogi Anand MrExcel MVP Joined Mar 12, 2002 Messages 11,454 Dec 1, 2005 #4 Hi bpflyer: Try ... =IF(LEN(J138),E138-J138,"")