1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Applying multiple row formulas to one cell

Greetings,

I have a list of bills with increases and some with percentage increases I am trying to write the proper formula for. I believe it would be a nested IF function.

For example, A1 = title, B1 would be current amount, C1 would be dollar increase, D1 would be percentage increase, E1 would be the increase amount, and F1 would be the total of E1 + B1.

How would I write the formula for E1 to calculate based off cells C1 or D1 either having an amount of be blank? So far I have figured out IF(C1="",0,C1+B1) but can't figure out how to also have D1 also apply same rules, except multiplying a percentage.

I know I could do this a more manual way, but I have a college degree that used a bit of Excel and am always trying to use it to keep skills sharp and learn things I can't figure out, on my own.

Appreciate any input!

submitted by /u/Zealousideal_Bag8757
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com