If with multiple or

  • Thread starter Thread starter TFMR
  • Start date Start date
T

TFMR

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
 
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
Click to expand...


Try this formula in cell C1:

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

Hope this helps / Lars-Åke
 
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).
 
Back
Top