Stuck into Present & Total Earned Days :(

Greeting to all Respectable people of the Forum

I have stuck into a simple issue which i cant figure it out

In my excel sheet I want cell "G11" to display "Zero" as Cell "C11" is zero

e.g: Present days of an employee is in cell C10 is 2 and Total Days Of the Month is "30" so after calculation working days will be 28 which is displaying ok.

But

when the Present days is Zero in Cells "C11:C14", why cells "G10:G14" is displaying Total Days Of the Month "30"

plz see the attachments of .xls & .Jpg

Cell Error.xls

Cell Error.jpg

any Help will be highly appreciated

Best regards

Please post a sample file. What is formula in G11?

Originally Posted by JohnTopley

Please post a sample file. What is formula in G11?

i have posted the sample file already plz find the attachment "Cell Error.xls"
thanks

Originally Posted by nflsales

=IF(C10<=0,0,($E10="Yes")+$C$5-D10-$F10)
TRY THIS AND COPY TOWARDS DOWN

Thanks for quick response,

when i enter value in cell "C11" and down then value displaying in cell "G11" to down across Total Days Of the Month "30".

Thanks " nflsales" its working great thanks a lot
your assistance is highly appreciated

Thread marked as Solved and Reputation has added

High Regards

Originally Posted by nflsales

Thanks for your feedback and adding reputation

You are very much welcome...

but their is some issue in the formula "when i enter Present days 1 in the cell "C11" its shows Earned Days " Total Days Of the Month "30"

can you plz help in it

Originally Posted by nflsales

If you explain what is your requirement then any one can help you

plz see the image attach

Cell Error 2.jpg

Originally Posted by nflsales

Then why G10 = 30

buz if you put 30 in C10 it will display 30 in G10 and
if you put "Zero" in C10 it will display "Zero" in G10

but

when you Put 29 in C10 and put Zero in "D10, E10 F10" than G10 will show 30 instead of 29

The current formula does not include adding/subtracting C11 or anything in column C

Should formula be:

=COUNTIF($E11,"Yes")+$C$5-D11-$C11

not

=COUNTIF($E11,"Yes")+$C$5-D11-$F11

Originally Posted by JohnTopley

The current formula does not include adding/subtracting C11 or anything in column C

Should formula be:

=COUNTIF($E11,"Yes")+$C$5-D11-$C11
not
=COUNTIF($E11,"Yes")+$C$5-D11-$F11

the formula should sum

Total Days Of the Month - Present - Leaves - Absent + One Leave Allowed = (Earned)

and

if Present is Zero than Earned should display = Zero

plz see the attachment

Cell Error 3.jpg

=IF(C10<=0,0,($E10="Yes")+$C$5-$C10-$D10-$F10)

Originally Posted by JohnTopley

=IF(C10<=0,0,($E10="Yes")+$C$5-$C10-$D10-$F10)

but if you enter 30 in C11 the G11 will become "Zero" instead of 30

You need to clearly define your rules which so far have not stated anything about C10 having a value of 30: if it does what is the effect on the other columns as you could get a negative number!