本文介绍了Excel公式的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

你好,


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

09-12 17:08