| if函数的应用 [message #189846] |
Mo, 10 April 2006 06:53 |
|
|
各位好朋友———怎样用IF函数求出分数中— 大于80的为“优”,大于70的为“良”,大于 60的为“好”,其余的为“差”。
|
|
|
| Re: ifӦ [message #189847 ] |
Mo, 10 April 2006 07:37 |
|
=IF(A1>=80,"",IF(A1>=70,"",IF(A1>=60,"","")))
--
ʼ!
"ΰΰΰΰΰΰΰ" < [at] discussions.microsoft.com> дʼ
news:8B2152F1-39D1-4D15-8CED-C7FEF0BDFD46 [at] microsoft.com...
> λѡIFС80Ϊš 70Ϊ
60ΪáΪ
|
|
|