IF statement

J

joemoran7

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
 
M

MDBCT

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

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