问一个Excel问题

[TIFF]

我想在一个单独的cell里用IF function 做下面的算数，请问怎么做呀？

IF A < N, a;
IF A >N and A<M, b;
Else, c.

谢谢！

 

[月下独酌]

http://office.microsoft.com/en-001/excel-help/if-HP005209118.aspx

 

[冷笑9声]

我想在一个单独的cell里用IF function 做下面的算数，请问怎么做呀？

IF A < N, a;
IF A >N and A<M, b;
Else, c.

谢谢！

啥公司啊还老整EXCEL。。不会.帮你喊一嗓：@老何

 

[TIFF]

http://office.microsoft.com/en-001/excel-help/if-HP005209118.aspx

IF我会用，但IF 和 AND联合那部分不会。

 

[TIFF]

啥公司啊还老整EXCEL。。不会.帮你喊一嗓：@老何

现在不用excel了？哪用什么？

 

[mate]

=IF(A<N,"a",IF(A<M,"b","c"))

 

[TIFF]

=IF(A<N,"a",IF(A<M,"b","c"))

你这个缺一个 A>N

Oh, wait, we don't need A>N.

 

[TIFF]

=IF(A<N,"a",IF(A<M,"b","c"))

It worked! Thanks!

 

[TIFF]

@mate 你知道怎么用 If 和 and 在一起吗？ 比方说， if a=0 and b=10, c

 

[uglyducking]

It worked! Thanks!

a==n 呢？

 

[TIFF]

a==n 呢？

help me, don't ask me, please.

 

[uglyducking]

help me, don't ask me, please.

c

 

[roller coaster]

@mate 你知道怎么用 If 和 and 在一起吗？ 比方说， if a=0 and b=10, c

=if(and(a=0,b=10), [value_if_true], [value_if_false])

 

[笨妈笨爸]

我想在一个单独的cell里用IF function 做下面的算数，请问怎么做呀？

IF A < N, a;
IF A >N and A<M, b;
Else, c.

谢谢！

If you are dealing with numbers, you do not need that stupid if function.
Simply doing something like this: =(A<N)*a+(A>=N)*(A<M)*b+(A>=M)*c, the idea here will also solve your another question above.
If you do not understand this and try to find the deeper reason, transfer your CFC money to me first.

 

[TIFF]

=if(and(a=0,b=10), [value_if_true], [value_if_false])

谢谢！