View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default


We don't quite have enough information for a complete answer, but here's
something to work with:

Assuming your values begin in Cell A1, put this in another column on
row 1 and copy down (eg. in Cell B1):

=if(A1=5014,L1-M1,0)

You didn't say what to do if Col A doesn't =5014, so that formula
returns a zero.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=394944