Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | RIP: James Earl Jones

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > General Discussion > Current Affairs
Register FAQ Community Calendar

Working out energy bills
Reply
 
Thread Tools
Old 13-09-2024, 10:37   #1
Hom3r
Mum 30/09/20 Dad 08/08/24
 
Hom3r's Avatar
 
Join Date: Mar 2004
Location: Galactic Sector ZZ9 Plural Z Alpha, A secret Moonbase (shh don't tell anybody)
Age: 56
Services: 2 x TiVo 360s, SH5. Samsung Galaxy Note 10+ 5G, Ton's of Smart Home stuff, & Cuddy Toy
Posts: 17,230
Hom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny stars
Hom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny stars
Working out energy bills

Ok, I'm trying to do a spreadsheet of my energy bill. (no smart meter here)

I need excel to tell me if my day rate of £0.29.09p and times this by the number of units 299 and times the together it will tell me it should cost roughly £88 for the month.

I can do £0.29p, but not £0.29.09p

Can anyone solve this so it will show £p?
__________________
I'm a Trustee & Secretary for a local charity

STAY AT HOME: I found out that mum will never walk again as the coronavirus attacked her nervous system. She died on September 30th.

Last edited by Hom3r; 13-09-2024 at 10:55.
Hom3r is offline   Reply With Quote
Advertisement
Old 13-09-2024, 10:44   #2
Taf
cf.mega poster
 
Taf's Avatar
 
Join Date: Jun 2003
Location: Kairdiff-by-the-sea
Age: 69
Services: TVXL BBXL Superhub 2ac (wired) 1Tb Tivo
Posts: 10,169
Taf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny star
Taf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny starTaf has a nice shiny star
Re: Working out energy bills

£0.2909?
Taf is offline   Reply With Quote
Old 13-09-2024, 10:58   #3
Hom3r
Mum 30/09/20 Dad 08/08/24
 
Hom3r's Avatar
 
Join Date: Mar 2004
Location: Galactic Sector ZZ9 Plural Z Alpha, A secret Moonbase (shh don't tell anybody)
Age: 56
Services: 2 x TiVo 360s, SH5. Samsung Galaxy Note 10+ 5G, Ton's of Smart Home stuff, & Cuddy Toy
Posts: 17,230
Hom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny stars
Hom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny starsHom3r has a pair of shiny stars
Re: Working out energy bills

Thanks
__________________
I'm a Trustee & Secretary for a local charity

STAY AT HOME: I found out that mum will never walk again as the coronavirus attacked her nervous system. She died on September 30th.
Hom3r is offline   Reply With Quote
Old 13-09-2024, 11:36   #4
Jaymoss
Just a Geek
 
Join Date: Jul 2015
Posts: 4,132
Jaymoss has a bronze arrayJaymoss has a bronze arrayJaymoss has a bronze array
Jaymoss has a bronze arrayJaymoss has a bronze arrayJaymoss has a bronze arrayJaymoss has a bronze arrayJaymoss has a bronze arrayJaymoss has a bronze arrayJaymoss has a bronze array
Re: Working out energy bills

my spreadsheet for this winds it up to 3 decimal places which is close enough for me
__________________
Is your muffin buttered? Would you like me to assign someone to butter your muffin?
Jaymoss is offline   Reply With Quote
Old 13-09-2024, 16:46   #5
Paul
Dr Pepper Addict
Cable Forum Team
 
Paul's Avatar
 
Join Date: Oct 2003
Location: Nottingham
Age: 62
Services: Aquiss FTTP (900M), Sky Q TV, Sky Mobile, Flextel SIP
Posts: 29,535
Paul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered stars
Paul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered stars
Re: Working out energy bills

Quote:
Originally Posted by Hom3r View Post
Can anyone solve this so it will show £p?
All I do is set that value 29.09, and divide the multiplied result by 100 for £.

You can format cells to display how you want as well (inc dp's) so I display it as 29.09p
__________________

Baby, I was born this way.
Paul is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 10:57.


Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum