Excel IF help

Closed
murock Posts 1 Registration date Saturday February 8, 2014 Status Member Last seen February 8, 2014 - Feb 8, 2014 at 07:21 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Feb 10, 2014 at 11:42 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Feb 10, 2014 at 11:42 AM
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
0