0 like 1 dislike
340 views
Dear Sir,

Klic Adv Excel  Assignment 12 सोडविण्यासाठी  help पाहिजे.

यातील अनेक assignment सोडवताना विदयार्थ्या बरोबरच  LF ला देखील लक्षात येत नाही. त्यामुळे अशा assignment ची solve केलेली video असायला हवी.

धन्यवाद...
asked Mar 28, 2018 in Feature Request by Jitendra Sir Intermediate (860 points) | 340 views

1 Answer

0 like 1 dislike

Respected Sir/Madam,

Pls do the following step to solve the Assignment 12.

--> Select cell J4

--> Type the following formula in J4

 --> =IF(AND(ISBLANK(G4),ISBLANK(H4)),INDIRECT($J$2),"")

--> Press Enter

--> Again select J4 cell and by using autofill handle drag upto cell J25, you will get the desired result.

Hint--> $J$2 makes the cell J2 absolute or type J2 and press F4 to make the cell absolute.

answered Mar 30, 2018 by IEITH Intermediate (1,110 points)
1,239 questions
1,682 answers
1,146 comments
7,219 users