Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards

Don't know what "start" is, but try this in C1:

=IF(B2<start,0,IF(B2=B1,"Remove",0))

Hope this helps.

Pete

On Jul 29, 12:28*pm, TFMR wrote:
Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards

On Tue, 29 Jul 2008 04:28:01 -0700, TFMR
wrote:

Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards


Try this formula in cell C1:

=IF(B2<"Start",0,IF(B2<B1,0,"Remove"))

Hope this helps / Lars-Åke

Shorter formula:

=IF(AND(B2=start,B2=B1),"Remove",0)
--
John C


"TFMR" wrote:

Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards

Thanks its working.

If I put formula in C2 and "Remove" returns in C1

"John C" wrote:

Shorter formula:

=IF(AND(B2=start,B2=B1),"Remove",0)
--
John C


"TFMR" wrote:

Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards

If you want remove to appear in C1, then the formula goes in C1. Without
using VBA, you can't have data populate a completely different cell based on
a separate cell (without it's own formula).
--
John C


"TFMR" wrote:

Thanks its working.

If I put formula in C2 and "Remove" returns in C1

"John C" wrote:

Shorter formula:

=IF(AND(B2=start,B2=B1),"Remove",0)
--
John C


"TFMR" wrote:

Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards