Prev: reformat dates to yyyy/mm/dd
Next: email a worksheet
From: Brad on 31 Mar 2010 11:18
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/aspnet/223c6e57-f81f-44b3-ab05-5995f2b0ab63/sharepoint-video-library.aspx
From: MH on 31 Mar 2010 12:01
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/aspnet/223c6e57-f81f-44b3-ab05-5995f2b0ab63/sharepoint-video-library.aspx
> .
>
From: Luke M on 31 Mar 2010 12:45
=IF(AND(B2="Jan",H2=1),G2,"")

--
Best Regards,

Luke M
<Brad Robinson> wrote in message news:2010331111851braduzzz(a)gmail.com...
> 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/aspnet/223c6e57-f81f-44b3-ab05-5995f2b0ab63/sharepoint-video-library.aspx


 | 
Pages: 1
Prev: reformat dates to yyyy/mm/dd
Next: email a worksheet