[Year 12 IT Apps] Query on Excel

[Mark Scott]

=ROUNDUP((B4*K8*I8)/I5,XX) where XX is the number of decimal places
needed eg 0 for no decimal places

 

Mark Scott

"We are what we pretend to be, so we must be careful what we pretend to
be." - Kurt Vonnegut
 

________________________________

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Diane Peat
Sent: Monday, 13 August 2007 8:28 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Query on Excel

 

Hello 

Firstly, my apologies if this appeared on the VELS list (poor reading on
my part). I have two queries I'm hoping someone can assist with:

 

Firstly 

1.	I want to protect the formula columns in my U4O1 spreadsheet, so
I use Tools, Protection, Protect Sheet. But if I do that, I can't type
into the two columns where I want to enter data. 
2.	If I only select the cells that contain the formulas and then
use the Format, Cells, Protection, it doesn't work and I can still alter
the formula cells. 
3.	If I do both lots of protection, I still can't type into the two
columns. 

 

I created a separate Data Entry sheet (thank Keith!) for the practice
SAC but I don't think it will work for the 'real' one I'm about to
start. Does anyone know if there's a way I can protect only a few
columns or cells, and still be able to enter data into other cells? I
thought I was OK with Excel, but am I missing something really basic???

 

Secondly

I want to round up a figure in my spreadsheet and can't remember how to
include the ROUNDUP criteria in my formula. I want to round up the
formula that reads =(B4*K8*I8)/I5 but I can't remember where to put
ROUNDUP. I know it's a simple thing but ...

 

 

Thanks everyone.

 

Diane Peat

Firbank Grammar School

BRIGHTON   

Telephone  9591 5118

Email  dpeat at firbank.vic.edu.au <mailto:dpeat at firbank.vic.edu.au> 

 

 

 

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
<http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%2
0> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070813/84cc6b6b/attachment-0001.html