Formula to calculate sheets of wall board

[bugs183]

Hiya!
This may seem like a daft question, but it's got me stumped and a friend who is brilliant with excel.

I need a formula to help me calculate sheets of wall board, i'll explain:

A sheet is 1.2 meters long, i'll put that number in A1.
A sheet is 0.6 meters high, i'll put that number in A2.

The wall length is 2.5 meters long, i'll put that in cell C1.
The wall height is 2.2 meters high, i'll put this number in cell C2.

So i need a formula that counts along the wall length C1(2.5), in multiples of cell A1 (1.2). Giving me a round number with no decimal place. This should be 3 in this instance. This is in cell E1
Then i'll use this formula to counts along the wall height C2(2.2) in multiples of cell A1 (1.2). Giving me a round number with no decimal place. This should be 4 in this instance. This goes in cell E2.
Then i'll multiply the two (E1xE2) to give me how many boards i need.

I'm not too bad at working formulas out but this has got me stumped!!!!

[Omegaman2]

I think you mean that you want to count the wall height using a2, not a1.

Try =even(c1/a1) for e1,
=even(c2/a2) for e2
and for your final answer, =e1*e2

of course you may not even need to have an e1, and an e2, you could skip those entirley if all you need is the final answer, by having:
=(even(c1/a1))*(even(c2/a2))

[bugs183]

Omegaman, you're a hero!!!
That's exactly what i was after. Thanks for the suggest of omitting E1, E2 I've been off Excel for a while so i'm a bit rusty.
Thanks very much, i'll pass on the knowledge of 'Even' to my friend.

[Omegaman2]

Glad it worked for you, it was nice to be able to answer something for once, instead of asking.

[bugs183]

I've just been through this and i'm sorry but it doesn't work properly, i thought it did but it was very late.
if a board is 1.2 meters long and a wall is under 1.2 meters it should return a 1 value then if the wall is longer than 1.2 the number returned should be two.
Any more ideas anyone???

[dredwolf]

try this

=ROUNDUP(C1/A1,0)*ROUNDUP(C2/A2,0)

-Edit-
had '+' instead of '*'
sorry for any confusion