View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin Vaughn
 
Posts: n/a
Default Adding a value from a different cell

In B1 put the formula

=a1 + 2

--
Kevin Vaughn


"atomicski" wrote:


Say there is a 5 in cell A1, I want cell B1 to display 7. So is there a
way to make a formula that does something like this? ex.
(A(variable)+2)=B(vairable)


--
atomicski
------------------------------------------------------------------------
atomicski's Profile: http://www.excelforum.com/member.php...o&userid=31744
View this thread: http://www.excelforum.com/showthread...hreadid=514562