IF - Nesting... almost got it - need a bit of help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AngelaG - 22 Aug 2005 22:07 GMT

=IF(S8="CLOSED","1","0")
Got that far... but need a final push

I need it to say - if =CLOSED 1
if =OPEN 0

If you feel so inclined to continue with my saga
Then I want these findings to carry over into colums B & C
B column IF(W8=1,"T8","")
C column IF(W8=0,"T8","")
am I headed in the right direction?

Thanks!!!!

Reply to this Message

Bill Kuunders - 22 Aug 2005 22:30 GMT

=IF(S8="CLOSED","1",if(S8="OPEN","0",""))
this will return text fields

if you want to return numbers 1 and 0 so that the B and C columns will be
able to recognise them
=IF(S8="CLOSED",1,if(S8="OPEN",0,""))

Signature

Greetings from New Zealand
Bill K

> =IF(S8="CLOSED","1","0")
> Got that far... but need a final push
[quoted text clipped - 9 lines]
>
> Thanks!!!!

Reply to this Message