Formula correction

[mukeshbaviskar]

Dear Friends,
Please correct the formula in column ‘t’. I want to use ‘or’ function but unable to do so. This is a leave register. In column ‘d’ there is a opening balance of casual leave and in column ‘j’ compensatory leave. My condition is:

if column ‘b’ contains ‘crcl’ then column ‘t’ should contain ‘crcl’
if column ‘b’ contains ‘crcp’ then column ‘t’ should contain ‘crcp’
for casual leaves refer column ‘d’ opening balance
for compensatory leave refer column ‘j’ opening compensatory leave
Please don’t change the remark in column ‘t’ referring to column ‘d’ and ‘j’ respectively. only I want to join these two conditions together using ‘or’ function. If there is a entry of ‘cl’ then it should refer column ‘d’ and for compensatory leave it should refer column ‘j’.

My formula is:

=IF(B8="crcp","CRCP",IF(B8="crcl","CRCL",IF(R8<=0," ",(IF(D8-R8<0,"Sn - "&ROUND(D8,1)&" day(s) & "&ROUND(R8-D8,1)&" day(s) wp","Sn - "&ROUND(R8,1)&" day(s)"),(IF(J8-R8<0,"Sn - "&ROUND(J8,1)&" day(s) & "&ROUND(R8-J8,1)&" day(s) wp","Sn - "&ROUND(R8,1)&" day(s)"))))))


Thank you.

Mukesh

[dilipandey]

Hi Mukesh,


Please correct the thread title to reflect the query you are asking.. at least you can mention about the formula name(s) which needs correction

see forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey
<click on below * if this helps>

[mukeshbaviskar]

Hello Deli,
Actually I want to combin the two formulas reletaded different cell address but have a same condition in remark column in 't' range 't8:t57'. I have used 'if' formula for it which fulfil my requirement but I fwant to combine these two formulas referring cell address 'd8' for 'cl' and column 'j' for compensatory leave cell address 'j8' respectively. I want the result in column 't8' respectively. I want to combin these two formulas with 'or' or 'and' or any sutable formula which give me the proper result in column 't'.
I'm unable to attach the attachment on line because of not able to drag the file with a help of keyboard. I follow the manage attachment option-add file-browse-upload button but in vain. In several attempts I'm unable to attach the file.
Please correct my formula please.
As per your suggestion I'm changing the name of threat.
Waiting to here from you soon with a solution.
Thank you.

Mukesh

[dilipandey]

Hi Mukesh,

Once you are in reply window, you'll find "go Advanced" option in bottom right, after clicking that you can find a paper clip icon to attach the file.
If your file size is greater than 1000kb, suggest you to zip that. Thanks.




Regards,
DILIPandey
<click on below * if this helps>