Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

请老翁帮忙，写个公式

0 views
Skip to first unread message

Red Imp

unread,
May 4, 2010, 7:10:57 AM5/4/10
to
��Ԫ��D1��ʽ��
���A1�е���ֵ<90�����жϵ�Ԫ��B1�е���ֵ<20,����D1����ʾ"����",���=>20<30,����ʾC1*85%�Ľ�����=>30<40,����ʾC1*80%�Ľ�����=>40,��ʾC1*75%�Ľ��
���A1�е���ֵ>90�����жϵ�Ԫ��B1�е���ֵ<30,����D1����ʾ"����",���=>30<40,����ʾC1*80%�Ľ�����=>40,��ʾC1*75%�Ľ��


������

unread,
May 4, 2010, 8:49:12 AM5/4/10
to
IF + AND

"Red Imp" <r...@imp.net> ׫����]����„:OawN5p36...@TK2MSFTNGP04.phx.gbl...

Red Imp

unread,
May 4, 2010, 9:19:42 AM5/4/10
to
�����
"������" <s...@47312.com> д����Ϣ����:%23f5nzg4...@TK2MSFTNGP06.phx.gbl...

��ү�

unread,
May 4, 2010, 11:01:25 PM5/4/10
to
�S�J�����窺,�д��
IF(AND(A1>=90,B1<30),"��",IF(AND(A1<90,B1>=40),C1*0.75,IF(AND(A1<90,B1>=30),C1*0.8,IF(AND(A1<90,B1>=20),C1*0.85,IF(AND(A1>=90,B1>=40),C1*0.75,IF(AND(A1>=90,B1>=30),C1*0.8,"��"))))))


"Red Imp" <r...@imp.net> ���g��l��s�D:uYQB3x46...@TK2MSFTNGP04.phx.gbl...


> �����
> "������" <s...@47312.com> д����Ϣ����:%23f5nzg4...@TK2MSFTNGP06.phx.gbl...
>> IF + AND
>>

>> "Red Imp" <r...@imp.net> ׫?��]����?:OawN5p36...@TK2MSFTNGP04.phx.gbl...

0 new messages