Corey

Something like

=IF(A1="Y",SUM(B1:D1)-E1,SUM(B1:D1))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Corey Brock" wrote in message
...
Is is possible to make a letter in a cell trigger an
equation. For example, if in a cell I put the letter "Y"
(for yes) it will add a group of cells then sugtract a
value from another cell to give me a total. But if I enter
the letter "N" (for no) then it will only add a group of
cells to give me a total without subtracting a value as it
did before?

Thanks,

Corey Brock