Formula,help please.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rahmad - 18 Mar 2007 12:19 GMT

Hi all,
I've tried to insert a formula to cell,but it seems
I can't figure it out.I want a formula that results
like below
If cell C7 = 0 it result is 0 , if C7 is 1 untill 6 it result 1,
if C7>6 it result =1.
How does to make it works.Please advise

Reply to this Message

jan - 18 Mar 2007 12:24 GMT

rahmad,

My translation from what you asked:

if C7=0 then 0
if C7<>0 then 1

You the can use:

=IF(C7=0;0;1)

or

=1*(C7<>0)

But probably my translation was not what you mentioned?

Jan

Reply to this Message

Max - 18 Mar 2007 13:20 GMT

Another thought ..
Maybe you mean:
=IF(C7="","",IF(C7=0,0,IF(AND(C7>0,C7<=1),"Undefined",1)))
Replace "Undefined" with the value that you want returned should C7 be
greater than 0 and less than 1. This was not mentioned in your post.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi all,
> I've tried to insert a formula to cell,but it seems
[quoted text clipped - 3 lines]
> if C7>6 it result =1.
> How does to make it works.Please advise

Reply to this Message

rahmad - 21 Mar 2007 06:23 GMT

ThANK'S Max,
It works perfectly.
Wish u have a nice day

> Another thought ..
> Maybe you mean:
[quoted text clipped - 14 lines]
> > if C7>6 it result =1.
> > How does to make it works.Please advise

Reply to this Message

rahmad - 21 Mar 2007 06:40 GMT

But sorry,
I was wrong in my previous message,
I want if C7>6 it results 0
Would you like to help?

> Another thought ..
> Maybe you mean:
[quoted text clipped - 14 lines]
> > if C7>6 it result =1.
> > How does to make it works.Please advise

Reply to this Message

joeu2004 - 21 Mar 2007 07:07 GMT

> I want a formula that results like below
> If cell C7 = 0 it result is 0 , if C7 is 1 untill 6 it result 1,
> if C7>6 it result =1.

> But sorry, I was wrong in my previous message,
> I want if C7>6 it results 0
> Would you like to help?

Perhaps the following will work for you:

=if(and(c7>=1,c7<=6), 1, 0)

Alternatively:

=1*and(c7>=1,c7<=6)

Note that this returns 0 if C7<0, a case that you did not cover.

Reply to this Message