Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating "IF" arguments
I can't seem to firgure out how to set up the following argument in an Excell
spreadsheet! IF cell B-6 has the value of "C" than cell J-6 = .8*H-6 and cell I-6 = .2*H-6 IF cell B-6 has the value of "P" than cell J-6 =SUM(H-6-E-6) The part I don't understand is how to incorporate the "IF" condition. Thanks to Anyone! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating "IF" arguments
If the only two options for B6 are "C" and "P", you can use:
J6 formula =IF(B6="C",0.8*H6,SUM(H6,E6)) I6 formula =IF(B6="C",0.2*H6) If you want the value to be something else (0 in this case) if B6 is not "C" or "P", use this: J6 formula =IF(B6="C",0.8*H6,IF(B6="P",SUM(H6,E6),0)) "REK" wrote: I can't seem to firgure out how to set up the following argument in an Excell spreadsheet! IF cell B-6 has the value of "C" than cell J-6 = .8*H-6 and cell I-6 = .2*H-6 IF cell B-6 has the value of "P" than cell J-6 =SUM(H-6-E-6) The part I don't understand is how to incorporate the "IF" condition. Thanks to Anyone! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating "IF" arguments
Dan has given the answer.
A point when writing/refereing to cells it's easier to just write J6, H6, E6 etc rather than J-6 H-6 E-6 Certainly makes H-6-E-6 less confusing to when it appears as H6-E6 :) Steve On Sat, 19 Aug 2006 02:50:26 +0100, REK <u25476@uwe wrote: I can't seem to firgure out how to set up the following argument in an Excell spreadsheet! IF cell B-6 has the value of "C" than cell J-6 = .8*H-6 and cell I-6 = .2*H-6 IF cell B-6 has the value of "P" than cell J-6 =SUM(H-6-E-6) The part I don't understand is how to incorporate the "IF" condition. Thanks to Anyone! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating username and passwords | Excel Worksheet Functions | |||
2 way Vlookup - Creating array arguments from columns | Excel Discussion (Misc queries) | |||
Formulae containing more than 7 arguments? | Excel Worksheet Functions | |||
multiple "if" arguments | Excel Discussion (Misc queries) | |||
creating function (vba) with range arguments | Excel Worksheet Functions |