iWork Numbers - Formula Help Please

-

hello

new numbers , new formulas in general need (please bear me).

have set own company , trying achieve this, want create spreadsheet tells me how many hours work each week , if week totals/equals on 40 hours week want next column tell me how many hours is.

have week having total cell @ end, such g4 = 41.

table has contracted hours set 40.

want h4 (next g4) tell me number 1, or if work 45, want calculate 5.

can lead on how cumulates on course of month.

simple thing achieve? can recommend formula sites?

in advance,

steve :)
 

enter in h4:

=x3-g4

= indicates entering formula
x3 cell reference of "40" cell - don't was
may need reference table name of "40" cell - don't remember how that, think numbers give cell picker enter "=".

google numbers formulas , should fine. there built-in help.
 


Forums Macs Mac Apps and Mac App Store


  • iPhone
  • Mac OS & System Software
  • iPad
  • Apple Watch
  • Notebooks
  • iTunes
  • Apple ID
  • iCloud
  • Desktop Computers
  • Apple Music
  • Professional Applications
  • iPod
  • iWork
  • Apple TV
  • iLife
  • Wireless

Comments

Post a Comment

Popular posts from this blog

Has to be the funniest headline ive ever seen

-
Image
http://www.ibtimes.com/articles/153911/20110528/apple-eyes-adultery-in-samsung-marriage.htm crazy headline aside see apple making moves. has samsung ever had innovation in life ?   oxide7 said: ↑ http://www.ibtimes.com/articles/153911/20110528/apple-eyes-adultery-in-samsung-marriage.htm crazy headline aside see apple making moves. has samsung ever had innovation in life ? click expand... that might news samsung well. can focus on building more exynos processors instead of ordering tegra2 nvidia account demand on current devices   Forums iPhone, iPad, and iPod Touch iPhone iPhone iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID...
Read more

Man Brings Goat to Apple Store and has Pizza Delivered

-
http://gothamist.com/2011/07/26/video_yes_you_can_bring_a_goat_into.php pretty funny.   i watched feature on living in ikea. entertaining!   Forums Mac Community Community Discussion iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID iCloud Desktop Computers Apple Music Professional Applications iPod iWork Apple TV iLife Wireless
Read more

@ Me address :)

-
Image
hi guys testing beta version of ios5 on phone atm. have @me.com address if want create 1 husband can ? if roll 4.3 still work? can use in outlook on normal pc? advise great cheers   you can create free icloud account work ios 5. possibly, generic functions email, contacts, calendars , find iphone work.   Forums Apple and Apple Services Apple Music, Apple Pay, iCloud, Apple Services iPhone Mac OS & System Software iPad Apple Watch Notebooks iTunes Apple ID iCloud Desktop Computers Apple Music Professional Applications iPod iWork Apple TV iLife Wireless
Read more