Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 . |
#6
|
|||
|
|||
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 . |
#7
|
|||
|
|||
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 . |
#8
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Formulas do not work in excel. | Excel Discussion (Misc queries) | |||
IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
duplicating excel formulas | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |