Excel Formulas
 

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

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

=IF(A1="Y",SUM(B2:B10)-C10,IF(A1="N",SUM(B2:B10),""))

Regards,

Peo Sjoblom

"Corey Brock" wrote:

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

Corey

I have presumed Y and N are the only options with my previous answer, you
could add another IF function to check for blanks or non entry of N or Y,
like so

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

--
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

Appreciate you help!

Corey
-----Original Message-----
Corey

I have presumed Y and N are the only options with my
previous answer, you
could add another IF function to check for blanks or non
entry of N or Y,
like so

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

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



"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


.

Another Question...

If I enter the word "bounced" in one cell can I trigger a
value in another cell ($500.00) to become a negative
number (-$500.00)?

Regrads,
Corey Brock



-----Original Message-----
Corey

I have presumed Y and N are the only options with my
previous answer, you
could add another IF function to check for blanks or non
entry of N or Y,
like so

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

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



"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


.

Not unless the cell with 500 holds a formula, if that's the case

=IF(A1="Bounced",-(formula),formula)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Corey Brock" wrote in message
...
Another Question...

If I enter the word "bounced" in one cell can I trigger a
value in another cell ($500.00) to become a negative
number (-$500.00)?

Regrads,
Corey Brock



-----Original Message-----
Corey

I have presumed Y and N are the only options with my
previous answer, you
could add another IF function to check for blanks or non
entry of N or Y,
like so

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

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



"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


.

See your other post*S*!

You've got 3 going on the same subject.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Corey Brock" wrote in message
...
Another Question...

If I enter the word "bounced" in one cell can I trigger a
value in another cell ($500.00) to become a negative
number (-$500.00)?

Regrads,
Corey Brock



-----Original Message-----
Corey

I have presumed Y and N are the only options with my
previous answer, you
could add another IF function to check for blanks or non
entry of N or Y,
like so

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

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



"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


.