Excel（If，And，OR）需要帮助

I have a value 30 in a cell A1 and 18 in A2. In another cell i need something like this:

我在单元格A1中有一个值30,在A2中有18。在另一个单元格中我需要这样的东西:

If A1*20% between 3.5 and 4 then 4 Else A1*20%

如果A1 * 20%介于3.5和4之间,那么4 Else A1 * 20%

Basically i want to check if the 20% of a number is between 3.5 and 4 if it is then i should display 4 and if the 20% is more then 4 then I should display the actual result. I need to write a single formula and drag it so that the formula will calculate accordingly and display result as "4" or the actual 20%.

基本上我想检查一个数字的20%是否介于3.5和4之间,如果是,那么我应该显示4,如果20%超过4,那么我应该显示实际结果。我需要编写一个公式并拖动它,以便公式将相应地计算并显示结果为“4”或实际的20%。

I have at least 10k rows with data.

我有至少10k行数据。

Any help is appreciated. Thanks.

任何帮助表示赞赏。谢谢。

1 个解决方案

#1

Try this

=IF(AND(A1*.2 >=3.5,A1*.2<=4),4,A1*.2)