Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |