|
There are isolated problems with current patches, but they are well-known and documented on this site. |
Hi all,
I could use your help. Please take a look at this screenshot of a Google Sheet — specifically, column F, which I calculate once a year.
I had help to calculate column D, which I do once a week. Here’s the formula (from D8):
=IF(LEN(B8)<1,"",C8/B7)
No doubt, the formula for column F just needs to tweak this, but I can’t quite figure it out. Any idea what to put in F8 and F16?
(I’ve already formatted column F as a percentage: Format/Number/Percent.)
Thank you so much!
The formula for percent change is:
(New Value – Old Value) / OldValue * 100
B8 B2 B8
F8 Formula: =IF($B8>0,($B8-$B2)/$B2,””)
In your case since you already have the column formatted as percentage you just drop the ‘* 100’.
BTW: I’d change the Col D formula to: =IF($B3>0,$C3/$B2,””)
Thanks so much, RetiredGeek! Did I do something wrong? I’m getting a “formula parse error” in F8. Here are screenshots. Thanks again.
If you did a copy/paste the quotes may be faulty. Try this one:
=IF($B8>0,($B8-$B2)/$B2,"")
cheers, Paul
How about in cell F8
=IF($B8>0,E8/B2,"")
..less typing
zeddy
..or even less typing in cell F8
=E8/B2
zeddy
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
