View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default calculating a value if adjacent cell has value

One way:

A3: =IF(B30, B2+1,"")

In article ,
Matt Stayton wrote:

I am trying to get a cell to perform a certain calculation if another cell
has a value placed in it larger than "0".

Column A Column B Column C
Row 1 Start End Total
Row 2 0 18 18
Row 3

I want cell A3 to calculate B2+1 only if B3 has a value larger than 0.
Otherwise I want the A3 to remain blank if nothing is entered in B3.

Thanks!