work with IF

[Little Master]

Once again Hi to all of u.


A1 contains date of purchase b1 contains date of sale & C1 contains the status.
For eg. If i purchase a scrip on 9 Oct 2005 & sell it on the same date the C2 shows status as "Intraday" ,similarly if i Purchase a scrip on 9 Oct 2005 & sell it on 12 Oct 2005 the C column shows the status as "Sold".But if i buy a scrip on 9 Oct 2005 & sells it on 10 Oct 2005 the C column shows the status "Intraday".Similarly if I buy a scrip on 09 Oct 2005 & dont sell till present date the C column shows "Holding".

For Eg.

A B C
9th Oct 9th Oct Intraday
9th Oct 10th Oct Intraday
9th Oct 12th Oct Sold
9th Oct

[Ian]

=IF(B1="","Holding",IF(B1-A1<=1,"Intraday","Sold"))

I'm assuming column B is blank until sold.

--
Ian
--
"Little Master" <[email protected]>
wrote in message
news:[email protected]...
>
> Once again Hi to all of u.
>
>
> A1 contains date of purchase b1 contains date of sale & C1 contains the
> status.
> For eg. If i purchase a scrip on 9 Oct 2005 & sell it on the same date
> the C2 shows status as "Intraday" ,similarly if i Purchase a scrip on
> 9 Oct 2005 & sell it on 12 Oct 2005 the C column shows the status as
> "Sold".But if i buy a scrip on 9 Oct 2005 & sells it on 10 Oct 2005 the
> C column shows the status "Intraday".Similarly if I buy a scrip on 09
> Oct 2005 & dont sell till present date the C column shows "Holding".
>
> For Eg.
>
> A B C
> 9th Oct 9th Oct Intraday
> 9th Oct 10th Oct Intraday
> 9th Oct 12th Oct Sold
> 9th Oct
>
>
> --
> Little Master
> ------------------------------------------------------------------------
> Little Master's Profile:
> http://www.excelforum.com/member.php...o&userid=28227
> View this thread: http://www.excelforum.com/showthread...hreadid=479728
>

[Little Master]

Thanks Ian it worked for me.

[Ian]

Glad to help. Thanks for the feedback.

--
Ian
--
"Little Master" <[email protected]>
wrote in message
news:[email protected]...
>
> Thanks Ian it worked for me.
>
>
> --
> Little Master
> ------------------------------------------------------------------------
> Little Master's Profile:
> http://www.excelforum.com/member.php...o&userid=28227
> View this thread: http://www.excelforum.com/showthread...hreadid=479728
>