How to add a set amount to cells with different values

Question

How to add a set amount to cells with different values

Anonymous

Each cell of Column H has a unique value, such as 30, 34.95, 29.99.... In Column I, I need to see those same values with 4.00 added to each. So in the attached example, the corresponding cells in Column I would have calculated to 34, 38.95 and 33.99. There are 377 unique rows, so doing this manually would not be efficient. I have no idea how to formulate this. TIA!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Rich~M 20,370 Volunteer Moderator

If I understand correctly and you want figures in Column I that are the Column H figure plus 4 you can use this.

=H2+4

Fill this down next to all of the figures in Column H.

If there are blank cells mixed in that don't need to be added, you can use this instead. The formula can then be filled into rows that don't have a number yet.

=IF(H2>0,H2+4,"")

0 comments