=if(a2,"","",if(w2<x2,ck$1))
Should this work in saying if x is greater than w then place ck1 in the cell?
...and I liked it.
Just spreading the education!!
My kids are the ones with blood link thinking other children are mine would be wrong on so many levels.
CEf
I'm after a free piece of knowledge....
I wish to type in cell A1 185 (eg) and in cells B1 and C1 it will split them into stones and pounds....
Ie +A1/14 etc gets me stone then figures there's 14 pounds and sticks the remaining in C3......?!
-------------
You've an hour.....
I need to know what a2 has to do with it.
Also, you need the FALSE result if x is less than w.
A2 is the name cell. Would a ,0 before end brackets work?
In fact not ,0 what about ,""?
MT
The formula in c1 is =MOD(a1,14)
Cool....
I'll be testing you some more tomorrow... !!
Thanks matey
Yes Petrov, but make sure it goes inside both end brackets.
Ok thanks. One more after assigning a macro to a text box. How do you unassign it without deleting the box?
Actually I have a general IT question....
On my baby laptop I can open a photo folder & see the contents of the photos and the actual photos without needing to open them individually..
On my big laptop I open a photo file & I can't see the photos!!' Annoying.. I'm assuming some missing software..?
Might help MT?
http://www.dummies.com/how-to/photography-video/digital-photography/using-the-computer.html
Dummies!!!!!!
My question is quite specific!!
Cheeky
Ohhhhhhh Orlando Bloom has arrived!!!
Petrov, delete the macro.
If you have it assigned to something else, then copy it under a different name. Delete original, and then rename copy.
That is the end of the free consultancy!!!! I have money to make
MT - it sounds like you haven't turned on the preview pane on your big laptop.
10 PRINT "YOU 3 NEED TO GET LAID"
20 GOTO 10
RUN
LH has just been dealing with two of the Saturdays while we have been talking spreadsheets.
And in the real world.......
"LH has just been dealing with two of the Saturdays while we have been talking spreadsheets."
Is that Latin for XNXX....?
XNXX is awesome. Xhamster is nearly as good. I don't know how I coped with the Sunday Sport and Baywatch back in the day.
I once got home from university and knocked one out to a buxon fairy godmother on CBBC.
Sign in if you want to comment
K.Davies shouldn't play anymore
Page 7 of 8
6 | 7 | 8
posted on 27/11/12
=if(a2,"","",if(w2<x2,ck$1))
Should this work in saying if x is greater than w then place ck1 in the cell?
posted on 27/11/12
...and I liked it.
Just spreading the education!!
posted on 27/11/12
My kids are the ones with blood link thinking other children are mine would be wrong on so many levels.
posted on 27/11/12
CEf
I'm after a free piece of knowledge....
I wish to type in cell A1 185 (eg) and in cells B1 and C1 it will split them into stones and pounds....
Ie +A1/14 etc gets me stone then figures there's 14 pounds and sticks the remaining in C3......?!
-------------
You've an hour.....
posted on 27/11/12
I need to know what a2 has to do with it.
Also, you need the FALSE result if x is less than w.
posted on 27/11/12
A2 is the name cell. Would a ,0 before end brackets work?
posted on 27/11/12
In fact not ,0 what about ,""?
posted on 27/11/12
MT
The formula in c1 is =MOD(a1,14)
posted on 27/11/12
Cool....
I'll be testing you some more tomorrow... !!
Thanks matey
posted on 27/11/12
Yes Petrov, but make sure it goes inside both end brackets.
posted on 27/11/12
Ok thanks. One more after assigning a macro to a text box. How do you unassign it without deleting the box?
posted on 27/11/12
Actually I have a general IT question....
On my baby laptop I can open a photo folder & see the contents of the photos and the actual photos without needing to open them individually..
On my big laptop I open a photo file & I can't see the photos!!' Annoying.. I'm assuming some missing software..?
posted on 27/11/12
Might help MT?
http://www.dummies.com/how-to/photography-video/digital-photography/using-the-computer.html
posted on 27/11/12
Dummies!!!!!!
My question is quite specific!!
Cheeky
posted on 27/11/12
You 3 need to get LAID.
posted on 27/11/12
Ohhhhhhh Orlando Bloom has arrived!!!
posted on 27/11/12
Petrov, delete the macro.
If you have it assigned to something else, then copy it under a different name. Delete original, and then rename copy.
That is the end of the free consultancy!!!! I have money to make
posted on 27/11/12
MT - it sounds like you haven't turned on the preview pane on your big laptop.
posted on 27/11/12
10 PRINT "YOU 3 NEED TO GET LAID"
20 GOTO 10
RUN
posted on 27/11/12
Awwwwww.
BASIC - bless
posted on 27/11/12
LH has just been dealing with two of the Saturdays while we have been talking spreadsheets.
posted on 27/11/12
And in the real world.......
posted on 27/11/12
"LH has just been dealing with two of the Saturdays while we have been talking spreadsheets."
Is that Latin for XNXX....?
posted on 27/11/12
XNXX is awesome. Xhamster is nearly as good. I don't know how I coped with the Sunday Sport and Baywatch back in the day.
posted on 27/11/12
I once got home from university and knocked one out to a buxon fairy godmother on CBBC.
Page 7 of 8
6 | 7 | 8