Yorkshire Divers

Deep Blue Technical
Go Back   YD Scuba Diving Forums > 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: Is there a way of adding to the formula that if I don't enter anything in F5 that it ...

Reply
Page 2 of 5 < 1 2 345 >
 
LinkBack Thread Tools Display Modes
  #11 (permalink)  
Old 10-03-08, 08:30 PM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,681
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
Is there a way of adding to the formula that if I don't enter anything in F5 that it will let me enter custom numbers ? or is this trying to take the P ?
__________________
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
  #12 (permalink)  
Old 10-03-08, 08:31 PM
Sixsquid's Avatar
Sixsquid Sixsquid is offline
Doing it anyway, anyhow, anywhere I please
  

Join Date: Sep 2005
Posts: 7,546
Sixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the water
Quote:
Originally Posted by Air Guzzler
just checking Adrian

Ive found excel to be a little bit to clever at times
Not as clever as the human brain

Just remember If then, else
__________________
"... once we start delving around in there it's obvious it's just a really, really big squid ...
...to be honest, I think we'll probably just eat it. "

"Wherever you go let your wind go free.
For it was keeping it in that was the death of me." - Tombstone wit
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #13 (permalink)  
Old 10-03-08, 08:31 PM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,681
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 Sixsquid
Or just use a lookup table
whats one of them ?!
__________________
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
  #14 (permalink)  
Old 10-03-08, 08:33 PM
Sixsquid's Avatar
Sixsquid Sixsquid is offline
Doing it anyway, anyhow, anywhere I please
  

Join Date: Sep 2005
Posts: 7,546
Sixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the water
Quote:
Originally Posted by colinicky
Is there a way of adding to the formula that if I don't enter anything in F5 that it will let me enter custom numbers ? or is this trying to take the P ?
Yes, amongst the many choices, if F5=" ", "helloooo"
__________________
"... once we start delving around in there it's obvious it's just a really, really big squid ...
...to be honest, I think we'll probably just eat it. "

"Wherever you go let your wind go free.
For it was keeping it in that was the death of me." - Tombstone wit
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #15 (permalink)  
Old 10-03-08, 08:37 PM
Sixsquid's Avatar
Sixsquid Sixsquid is offline
Doing it anyway, anyhow, anywhere I please
  

Join Date: Sep 2005
Posts: 7,546
Sixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the water
Quote:
Originally Posted by colinicky
whats one of them ?!
Golly, haven't done it in a while and don't have Excel in front of me
Probably Vlookup
Go into the Formulae wizard and play around. It's usually easy to follow and often more simple than you having to write a full string of "if, then else"
Less chance of forgetting a ')' too

Sorry. You asked What's one of them, not which. See a new post
__________________
"... once we start delving around in there it's obvious it's just a really, really big squid ...
...to be honest, I think we'll probably just eat it. "

"Wherever you go let your wind go free.
For it was keeping it in that was the death of me." - Tombstone wit
Last edited by Sixsquid : 10-03-08 at 08:44 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #16 (permalink)  
Old 10-03-08, 08:38 PM
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,580
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
Is there a way of adding to the formula that if I don't enter anything in F5 that it will let me enter custom numbers ? or is this trying to take the P ?
Quote:
Originally Posted by big_si
So let me get this straight... You want the value in H5 to perform a different calculation based on what the value in F5 is?

so... in cell H5 put

=IF(F5=0,F5,IF(F5=1,F5/1.175,IF(F5=2,F5/1.05,IF(F5=4,F5/407*7,"NOT VALID VALUE"))))

Should do the trick
You could enter a custom value if you just paste this over the bold text

IF(F5="X",F3,"NOT VALID VALUE")


in F5 enter X and in the other specified cell (in this example F3) what you want it to be.
__________________
Veni Vidi Divi!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #17 (permalink)  
Old 10-03-08, 08:41 PM
Sixsquid's Avatar
Sixsquid Sixsquid is offline
Doing it anyway, anyhow, anywhere I please
  

Join Date: Sep 2005
Posts: 7,546
Sixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the water
Right,

a look up table will contain a bunch on of data in an ordered manner
You can reference it like a grid in battleships so Excel pops along and says, I have an 'x' so I'm gonna find the corresponding result for this 'x' and return it to this cell

Make any sense ?
__________________
"... once we start delving around in there it's obvious it's just a really, really big squid ...
...to be honest, I think we'll probably just eat it. "

"Wherever you go let your wind go free.
For it was keeping it in that was the death of me." - Tombstone wit
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #18 (permalink)  
Old 10-03-08, 08:42 PM
colinicky colinicky is offline
Driving my truck with my high-heels on...
  

Join Date: Sep 2004
Location: SE
Posts: 2,681
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 Sixsquid
Right,

a look up table will contain a bunch on of data in an ordered manner
You can reference it like a grid in battleships so Excel pops along and says, I have an 'x' so I'm gonna find the corresponding result for this 'x' and return it to this cell

Make any sense ?
Ermmm no plus your if F5=" ", "helloooo" didn't work !
__________________
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
  #19 (permalink)  
Old 10-03-08, 08:47 PM
Sixsquid's Avatar
Sixsquid Sixsquid is offline
Doing it anyway, anyhow, anywhere I please
  

Join Date: Sep 2005
Posts: 7,546
Sixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the waterSixsquid is never out of the water
Quote:
Originally Posted by colinicky
Ermmm no plus your if F5=" ", "helloooo" didn't work !
Sorry Hard to explain here and I misunderstood the other question. Big Si's answer to that should work

I'll see if there's a way I can explain the lookup table better
__________________
"... once we start delving around in there it's obvious it's just a really, really big squid ...
...to be honest, I think we'll probably just eat it. "

"Wherever you go let your wind go free.
For it was keeping it in that was the death of me." - Tombstone wit
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #20 (permalink)  
Old 10-03-08, 08:48 PM
Adrian Kelland's Avatar
Adrian Kelland Adrian Kelland is offline
Pimp my user title
  

Join Date: May 2003
Location: Exeter
Posts: 8,466
Adrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fishAdrian Kelland communes with fish
Quote:
Originally Posted by Air Guzzler
just checking Adrian

Ive found excel to be a little bit to clever at times
My gripe is that it is if(test,then,else) in Excel and iif(test,then,else) in Access. Still keeps me employed, sorting out other peoples cockups, I mean data.
__________________
Interviewer; Sum yourself up in three words
Me; Lazy
YD Fundraising 2007/8 - Amount Raised Royal National Lifeboat Institution UK Transplant Register Exeter BSAC
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply
Page 2 of 5 < 1 2 345 >

« 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 11:00 PM.
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