Problems with formula inside a tab cell

Discuss the spreadsheet application

Problems with formula inside a tab cell

Postby Jacky » Sat May 17, 2008 12:33 pm

Hi!

I´m experiencing a strange problem while trying to embed some formula into a text.

Let´s say that I want to add the numbers of cell C3 to C5 and display the sum in C6. The formula would be

= sum<C3:C5>

Works fine for that. But in the cell below, I need to calculate the tax - that is 7 percent - and display it in this cell (C7).

The formula I used for that is simple: =(C6/100)*7

But it doesn´work. The number displayed in C7 is always zero :-( I can´t figure out, why. It´s simple mathematics but it doesn´t work.

Any ideas? Thank you for your help!

-Jacky
Jacky
 
Posts: 1
Joined: Sat May 17, 2008 12:24 pm

Re: Problems with formula inside a tab cell

Postby Dave » Sat May 17, 2008 2:26 pm

Check the cell formatting ...number of decimals etc..

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests