Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double If Statement help
Hi
I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan then if the answer is Jan, then look in column "h2", to see if it contains a "1" (it will either contain a "1" or nothing). If it does i need it to take the value out of column G2 (which will be a number) and paste it in the cell im typing the formula into to. Hope This makes sense any help will be greatly appreciated. Thanks Submitted via EggHeadCafe - Software Developer Portal of Choice SharePoint Video Library Template Available For Download http://www.eggheadcafe.com/tutorials...o-library.aspx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double If Statement help
this should work
=IF(B2="Jan",IF(H2=1,G2,"")) -- MH "Brad Robinson" wrote: Hi I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan then if the answer is Jan, then look in column "h2", to see if it contains a "1" (it will either contain a "1" or nothing). If it does i need it to take the value out of column G2 (which will be a number) and paste it in the cell im typing the formula into to. Hope This makes sense any help will be greatly appreciated. Thanks Submitted via EggHeadCafe - Software Developer Portal of Choice SharePoint Video Library Template Available For Download http://www.eggheadcafe.com/tutorials...o-library.aspx . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Double If Statement help
=IF(AND(B2="Jan",H2=1),G2,"")
-- Best Regards, Luke M <Brad Robinson wrote in message ... Hi I am trying to create a formula that will look in column "b2" which will be a reference to a month i.e Jan then if the answer is Jan, then look in column "h2", to see if it contains a "1" (it will either contain a "1" or nothing). If it does i need it to take the value out of column G2 (which will be a number) and paste it in the cell im typing the formula into to. Hope This makes sense any help will be greatly appreciated. Thanks Submitted via EggHeadCafe - Software Developer Portal of Choice SharePoint Video Library Template Available For Download http://www.eggheadcafe.com/tutorials...o-library.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Purpose of Double Unary in AND Statement | Excel Worksheet Functions | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Using "double equal signs" in place of an IF statement | Excel Worksheet Functions | |||
Double if statement | Excel Worksheet Functions |