Meet the Other Phone. Only the apps you allow.

Meet the Other Phone.
Only the apps you allow.

Buy now

Please or to access all these features

Geeky stuff

Who's brilliant at spreadsheet formula's?

19 replies

sweetheart · 09/02/2011 12:30

I need a formula in a sheet which says if this figure in box B3 is 250 or less the answer needs to be 1% but if the figure in box B3 is more than 250 the answer needs to be 3%.

Does that make sense?

OP posts:
smellyfeet · 09/02/2011 12:33

=IF(B3

smellyfeet · 09/02/2011 12:33

Actually
=IF(B3

sweetheart · 09/02/2011 13:52

Hmm the formula seems to work - ish but it comes up with the word false instead of a figure - any other ideas? I need it to be the percentage of the figure in B3

OP posts:
stealthsquiggle · 09/02/2011 13:55

=IF(B3

stealthsquiggle · 09/02/2011 13:56

Oh, sorry - so it needs to be 1% of B3 or 3% of B3?

stealthsquiggle · 09/02/2011 13:57

in which case it would be

=IF(B3

TrillianAstra · 09/02/2011 13:58

=IF(B3

TrillianAstra · 09/02/2011 13:58

or what stealth said.

sweetheart · 09/02/2011 15:02

thank you - that's brilliant Grin

OP posts:
stealthsquiggle · 09/02/2011 17:48
TrillianAstra · 09/02/2011 20:39

You don't have your towel with you? Shocking! :o

sweetheart · 09/02/2011 22:03

ummmm, why do you need a towel? Confused

OP posts:
BertieBotts · 09/02/2011 22:04

You must ALWAYS know where your towel is!

stealthsquiggle · 09/02/2011 22:45

I may not have it, but I think I know where it is.

(sorry, OP (I just cannot type your name - it's too close to calling people 'hun') - obscure cultural references related to Trillian's name)

threefeethighandrising · 09/02/2011 22:58

From Wikipedia:

Knowing where one's towel is

Somebody who can stay in control of virtually any situation is somebody who is said to know where his or her towel is. The logic behind this statement is presented in chapter 3 of The Hitchhiker's Guide to the Galaxy thus:

"... a towel has immense psychological value. For some reason, if a strag (strag: nonhitchhiker) discovers that a hitchhiker has his towel with him, he will automatically assume that he is also in possession of a toothbrush, washcloth, soap, tin of biscuits, flask, compass, map, ball of string, gnat spray, wet-weather gear, space suit etc., etc. Furthermore, the strag will then happily lend the hitchhiker any of these or a dozen other items that the hitchhiker might accidentally have "lost". What the strag will think is that any man who can hitch the length and breadth of the galaxy, rough it, slum it, struggle against terrible odds, win through, and still knows where his towel is, is clearly a man to be reckoned with."

Grin
threefeethighandrising · 09/02/2011 23:05

If you've not had the good fortune to read The Hitchhikers' Guide to the Galaxy (or heard the original radio series) yet then I suggest you remedy that a.s.a.p.

Or if it doesn't look like your cup of tea, buy a copy anyway and give it to the nearest 13 - 130 year old with the slightest interest in sci-fi / humour.

One of my favourite books of all time (can you tell? Grin)

TrillinaAstra I had name-envy when I first saw your name BTW!

stealthsquiggle · 10/02/2011 07:48

Just don't watch the film - it bears no relation to the real thing!

threefeet - have you met slartybartfast (on MN)?

TrillianAstra · 10/02/2011 08:54

Oh but in the new film I get to be the gorgeous Zooey rather than a blonde 80s woman with big hair.

stealthsquiggle · 10/02/2011 09:03

true, Trillian, but that doesn't make up for what they did to Marvin.

I shall stick with the book/radio series [old gimmer]

New posts on this thread. Refresh page