问题描述
你好，
我对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
提前谢谢！
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!
这篇关于Excel公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！