Yorkshire Divers

Deep Blue Technical
Go Back   YD Scuba Diving Forums & Community > Non-Diving Related Forums > Technology
Excel formula Writing help Excel formula Writing help
User Name
Password

Welcome to the YD Scuba forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

Technology: Discuss Excel formula Writing help in the Non-Diving Related Forums forums: ....

Reply
Page 5 of 5 < 1234 5
 
LinkBack Thread Tools Display Modes
  #41 (permalink)  
Old 10-03-08, 10:32 PM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,677
colinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkeller
.
__________________
Colin

I trust my rebreather completely ,
I just don't trust the user

onwards & downwards
Last edited by colinicky : 10-03-08 at 10:33 PM. Reason: lost the plot !
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #42 (permalink)  
Old 11-03-08, 02:44 AM
Dibbler's Avatar
Dibbler Dibbler is offline
...
Recent Blog: Jervis Bay
  

Join Date: May 2005
Location: Sydney
Posts: 126
Dibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annuallyDibbler dips toes in sea annually
Post A note
A problem with Nested If's in excel (certainly older versions anyway)
is you can only nest i think 7 deep and after that it just fails with no helpful error message...So you spend hours counting brackets then give up

'Choose' sounds much better more like 'CASE' than 'IF'
__________________
Simon Ashmore
'I don't approve of political jokes, I've seen too many of them get elected'
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #43 (permalink)  
Old 11-03-08, 06:56 AM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,677
colinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkeller
Quote:
Originally Posted by Janos

=CHOOSE(F5+1, F5, F5/1.175, F5/1.05, 0, F5/(407*7))

Janos

Janos
For some reason it fails on the last .
F5/(407*7) If F5 =407 then the answer should work out to be 7 ie
407/407*7 =7
but your way is
407/(407*7)
407/(2849)=0.14
__________________
Colin

I trust my rebreather completely ,
I just don't trust the user

onwards & downwards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #44 (permalink)  
Old 11-03-08, 07:02 AM
big_si's Avatar
big_si big_si is offline
The man who put a big smile on Tanya Streeters face
  

Join Date: Aug 2006
Location: Royston, Herts, UK
Posts: 4,579
big_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the waterbig_si is never out of the water
Quote:
Originally Posted by colinicky
Janos
For some reason it fails on the last .
F5/(407*7) If F5 =407 then the answer should work out to be 7 ie
407/407*7 =7
but your way is
407/(407*7)
407/(2849)=0.14
Does it work correctly if the brackets are removed?
__________________
Veni Vidi Divi!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #45 (permalink)  
Old 11-03-08, 07:13 AM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,677
colinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkellercolinicky is a snorkeller
Quote:
Originally Posted by big_si
Does it work correctly if the brackets are removed?
Yep was just away playing with it !
__________________
Colin

I trust my rebreather completely ,
I just don't trust the user

onwards & downwards
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 5 of 5 < 1234 5

« Which accounting software ? | Sub £350 Camcorder »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Sponsored Links

Yorkshire Divers - RSS Feed
All times are GMT +1. The time now is 05:04 AM.
Powered by vBulletin
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.0.0 RC6
Trademark and all rights reserved : © YD.com Ltd (2006)
YD.com Ltd (Registered in England - 05886696)
Other sites : Golf Clubs | New Premiership Football Kits | MP3 Portable Players | MP3 Players For Sale | Replica Football Kits

Advertise - Contact Us - Yorkshire Divers - Sitemap - Privacy Statement - Terms & Conditions - Top
Forums Directory