Excel公式 [英] Excel Formula

问题描述

你好，


我对Excel不好，我真的很感谢以下方面的帮助：


请告诉我们我可以将所有这些放在一个字段中，让我们说AN100。


如果U100（列U，第100行的值）小于AJ100，则AN100应为= D100 * 1

如果U100小于AJ100而AK100比AN100应该= 0

如果U100大于AL100而不是AN100应该= = D100 * 3

如果U100大于AL100且AM100大于AN100应为= D100 * 4

如果U100大于AJ100和AK100，但小于AL100且AM100单元AN100应为= D100 * 2


如何将所有这些压缩到AN100领域？


（有没有办法让Excel颜色为不同颜色的AN细胞，满足上述哪些条件？）


此外，我还需要以下方面的帮助：


如果U100（列U，行100中的值）小于t如果U100小于AJ100而AK100比AO100小，则价值为0

如果U100比AL100大于AO100应该有值3，那么AJ100比AO100应该有价值1



如果U100大于AL100且AM100比AO100值4，那么
如果U100大于AJ100和AK100，但小于AL100且AM100单元AO100应具有价值2


提前谢谢！

解决方案

各种值是否有任何已知的顺序？

EG。 AJ总是大于AK。

Hello NeoPa。


AJ总是大于AK。

AL总是小于AM。


谢谢！

AM能否小于AK？

AL能否小于AJ？

Hello,

I am not good with Excel and I would truly appreciate assistance with the following:

Please let me know how I can place all of this in one field, let?s say AN100.

If U100 (column U, value in row 100) is smaller than AJ100 than AN100 should be =D100*1
If U100 is smaller than AJ100 and AK100 than AN100 should be =0
If U100 is bigger than AL100 than AN100 should be =D100*3
If U100 is bigger than AL100 and AM100 than AN100 should be =D100*4
If U100 is bigger than AJ100 and AK100, but smaller than AL100 and AM100 cell AN100 should be =D100*2

How can I squeeze all of this into field AN100?

(Is there any way to make Excel colour AN cells in different colours, subject to which of the conditions above are met?)


Also, I need assistance with the following as well:

If U100 (column U, value in row 100) is smaller than AJ100 than AO100 should have value 1
If U100 is smaller than AJ100 and AK100 than AO100 should have value 0
If U100 is bigger than AL100 than AO100 should have value 3
If U100 is bigger than AL100 and AM100 than AO100 should have value 4
If U100 is bigger than AJ100 and AK100, but smaller than AL100 and AM100 cell AO100 should have value 2


Thank you in advance!

解决方案

Is there any known order of the various values?
EG. AJ always greater than AK.

Hello NeoPa.

AJ is always greater than AK.
AL is always smaller than AM.

Thank you!

Can AM ever be smaller than AK?
Can AL ever be smaller than AJ?

这篇关于Excel公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！