Excel IF help [Closed]

Report
Posts
1
Registration date
Saturday February 8, 2014
Status
Member
Last seen
February 8, 2014
-
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
-
Hello,

I am looking for a function I think an IF statement for some accounts. I want to say

IF ( The value in column B="Tom")
THEN (Add the value in the corresponding cell in column D to the total of this cell)
ELSE (Add 0 to the total of this cell)

By corresponding value I mean B1 corresponds to D1, B6 to D6, etc...

Thanks


1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Murock,

It is not possible to put a value and a formula in one cell.

You could use a macro but the most common way is to use an extra column.

Formula would look like:
=IF(B1="Tom",C1+D1,C1)
In addition you can choose to hide column C if you don't want to see it.

Best regards,
Trowa