Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
I hope some one can help me... I'm been trying to get this to work for 5 days
now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
try:
=IF(ISNUMBER(E10),H10*(1+LOOKUP(E10,{0,1,2,3},{0,0 .15,0.22,0.5})),H10) "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
Try something like this:
=H10*CHOOSE(E10+1,1,0.15,0.22,0.5) Does that help? *********** Regards, Ron XL2002, WinXP "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
You's are very good here!!!! Yes It did!!! I like that!!! Thank you so
much!!!! I see there are different ways to do this also as topper has shown. Thanks for the help!!! Joe "Ron Coderre" wrote: Try something like this: =H10*CHOOSE(E10+1,1,0.15,0.22,0.5) Does that help? *********** Regards, Ron XL2002, WinXP "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
You's are very good here!!!! Yes It did help!!! I like that. Thank you so
much!!!! I see there are different ways to do this also as Ron has shown. Thanks for the help!!! So is it possable to make the Total Cell color change automaticly to red when a # is entered into the e10 cell? Joe "Toppers" wrote: try: =IF(ISNUMBER(E10),H10*(1+LOOKUP(E10,{0,1,2,3},{0,0 .15,0.22,0.5})),H10) "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
You're very welcome.....Glad to help.
*********** Regards, Ron XL2002, WinXP "j5b9721" wrote: You's are very good here!!!! Yes It did!!! I like that!!! Thank you so much!!!! I see there are different ways to do this also as topper has shown. Thanks for the help!!! Joe "Ron Coderre" wrote: Try something like this: =H10*CHOOSE(E10+1,1,0.15,0.22,0.5) Does that help? *********** Regards, Ron XL2002, WinXP "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
select Total cells
Format=Conditional formatting Formula Is: =ISNUMBER(E10) ("=" required) Pattern- select RED OK. "j5b9721" wrote: You's are very good here!!!! Yes It did help!!! I like that. Thank you so much!!!! I see there are different ways to do this also as Ron has shown. Thanks for the help!!! So is it possable to make the Total Cell color change automaticly to red when a # is entered into the e10 cell? Joe "Toppers" wrote: try: =IF(ISNUMBER(E10),H10*(1+LOOKUP(E10,{0,1,2,3},{0,0 .15,0.22,0.5})),H10) "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
Hi Ron...
I am having a little trouble with (I10) when nothing is entered into (E10) I get (H10)'s total. Can that be removed? Joe "Ron Coderre" wrote: You're very welcome.....Glad to help. *********** Regards, Ron XL2002, WinXP "j5b9721" wrote: You's are very good here!!!! Yes It did!!! I like that!!! Thank you so much!!!! I see there are different ways to do this also as topper has shown. Thanks for the help!!! Joe "Ron Coderre" wrote: Try something like this: =H10*CHOOSE(E10+1,1,0.15,0.22,0.5) Does that help? *********** Regards, Ron XL2002, WinXP "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
Perhaps something like this:
=H10*CHOOSE(E10+1,0,0.15,0.22,0.5) or this..... =IF(E10,H10*CHOOSE(E10,0.15,0.22,0.5),"") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "j5b9721" wrote: Hi Ron... I am having a little trouble with (I10) when nothing is entered into (E10) I get (H10)'s total. Can that be removed? Joe "Ron Coderre" wrote: You're very welcome.....Glad to help. *********** Regards, Ron XL2002, WinXP "j5b9721" wrote: You's are very good here!!!! Yes It did!!! I like that!!! Thank you so much!!!! I see there are different ways to do this also as topper has shown. Thanks for the help!!! Joe "Ron Coderre" wrote: Try something like this: =H10*CHOOSE(E10+1,1,0.15,0.22,0.5) Does that help? *********** Regards, Ron XL2002, WinXP "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need HELP with "IF" "THEN" I think????
I do think that will work...
I hope!!! I take them out for a test drive!!! Thanks again!!! Joe "Ron Coderre" wrote: Perhaps something like this: =H10*CHOOSE(E10+1,0,0.15,0.22,0.5) or this..... =IF(E10,H10*CHOOSE(E10,0.15,0.22,0.5),"") Is that something you can work with? *********** Regards, Ron XL2002, WinXP "j5b9721" wrote: Hi Ron... I am having a little trouble with (I10) when nothing is entered into (E10) I get (H10)'s total. Can that be removed? Joe "Ron Coderre" wrote: You're very welcome.....Glad to help. *********** Regards, Ron XL2002, WinXP "j5b9721" wrote: You's are very good here!!!! Yes It did!!! I like that!!! Thank you so much!!!! I see there are different ways to do this also as topper has shown. Thanks for the help!!! Joe "Ron Coderre" wrote: Try something like this: =H10*CHOOSE(E10+1,1,0.15,0.22,0.5) Does that help? *********** Regards, Ron XL2002, WinXP "j5b9" wrote: I hope some one can help me... I'm been trying to get this to work for 5 days now!!! HELP!!!! LOL I need a formula that I copy and paste into a cell down a spread sheet Not using a macro or pivot table. I dont know how to set them up. In a cell (E10 is a Diffulicty factor) I need to enter (Nothing,1, 2, or 3) Nothing entered is = No change to any cells 1 is to .15 % increase 2 is to = .22 % 3 is to = .5 % Then a cell that will take that % and Multiply another cell into a 3rd cell. E10*H10 = I10 total |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |