[jaws-uk] Re: entering excel formula with jfw
- From: "Jamie Cuthbertson" <jamie.cuthbertson@xxxxxxxxxxxx>
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Mon, 9 Mar 2009 15:00:19 -0000
Also check in the "Tools" "Options" "View" tab that you have not activated
the option to do with Formula . If this check box is checked, you will get
exactly what you describe here.
Regards,
Jamie
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] On
Behalf Of Robin Clayden
Sent: 09 March 2009 14:53
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: entering excel formula with jfw
Should do, but check the cell where you're inserting your formula,
sounds like it's set to text?
R
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Adrian Higginbotham
Sent: 09 March 2009 14:45
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: entering excel formula with jfw
Thanks - just had that thought too - presumably formatting cells as
currency should allow formula to work?
Adrian Higginbotham,
Manager, Leading edge research
Tel: Direct dial 024 7679 7333 - Becta switchboard 02476-416994
Email: Adrian.Higginbotham@xxxxxxxxxxxx
Web: http://www.becta.org.uk/
BECTA, Millburn Hill Road, Science Park, Coventry, CV4 7JJ
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Robin Clayden
Sent: 09 March 2009 14:38
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: entering excel formula with jfw
Hi,
Check your cell format.... Just a thought
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Adrian Higginbotham
Sent: 09 March 2009 14:34
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] entering excel formula with jfw
Hi - new to creating my own excel formula having generally worked in the
past with spreadsheets with formula already in place.
Anyone tell me where I'm going wrong in that when I enter a formula
which seems to be in the correct format jfw only reads out the formula
not the result of it when I return to that cell.
EG if I want to sum the total of figures in column B, rows, 2 3 and 4
the formula should be =SUM(B2:B4) shouldn't it? I've tried typing this
straight in to a cell (b5) or pressing f2 and then entering it in but
either way as above jaws just repeats the formula doesn't announce the
total of those figures.
Where am I going wrong?
Thanks for any help.
Adrian Higginbotham,
Manager, Leading edge research
Tel: Direct dial 024 7679 7333 - Becta switchboard 02476-416994
Email: Adrian.Higginbotham@xxxxxxxxxxxx
Web: http://www.becta.org.uk/
BECTA, Millburn Hill Road, Science Park, Coventry, CV4 7JJ
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Edinburgh College of Art (eca) is a charity registered in Scotland,
number SC009201
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Edinburgh College of Art (eca) is a charity registered in Scotland, number
SC009201
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
