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