ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel formula problem (https://www.excelbanter.com/excel-discussion-misc-queries/447011-excel-formula-problem.html)

gopiganji

excel formula problem
 
1 Attachment(s)
Hi,

I Have a Excel Formula Problem.

I have already set the formula in that cell

BASIC HRA CONV WASH TOTAL Working days BASIC HRA CONV WASH
24000 1000 6000 0 40000 0

When i choose "0 " Working days all ie.Working days,BASIC,HRA,CONV,WASH should be "0".Formula is there in all the cell but its not working.

What is the Problom?

thanks
Gopi

Ron Rosenfeld[_2_]

excel formula problem
 
On Mon, 3 Sep 2012 11:41:57 +0000, gopiganji wrote:


Hi,

I Have a Excel Formula Problem.

I have already set the formula in that cell

BASIC HRA CONV WASH TOTAL Working days BASIC HRA CONV
WASH
24000 1000 6000 0 40000 0


When i choose "0 " Working days all ie.Working days,BASIC,HRA,CONV,WASH
should be "0".Formula is there in all the cell but its not working.

What is the Problom?

thanks
Gopi


+-------------------------------------------------------------------+
|Filename: 2.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=565|
+-------------------------------------------------------------------+


Either your formulas are incorrect, and, of course, the formulas will not show up on your jpeg attachment; or your workbook is set to manual calculation.


All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com