ExcelBanter - If function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If function (https://www.excelbanter.com/excel-discussion-misc-queries/189519-if-function.html)

Kevin

If function

I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.

JE McGimpsey

If function

One way:

=10*COUNTIF(B2:AH2,"Y")

In article ,
Kevin wrote:

I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.

Todd A

If function

Hello Kevin,

Did the previous response help you?

"Kevin" wrote:

I would like AI to to add 10 for every cell (B2:AH2) that has Y in it.

All times are GMT +1. The time now is 01:26 PM.