Thread: IF statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MDBCT
 
Posts: n/a
Default IF statement

=if(Cell ="No",D4+B6,D4)

The formula assumes that if the cell is any value other than "No", show D4

"joemoran7" wrote:


i need to use an IF statement to do if a cell="No" then D4+B6, but if
the cell="Yes" then do not add B6 to D4 so the answer will just be D4.

can anyone help please


--
joemoran7