Previous Topic Next Topic

Excel

Solved/Closed
dush09 Posts 8 Registration date Monday February 4, 2013 Status Member Last seen February 11, 2013 - Feb 4, 2013 at 01:58 AM
dush09 Posts 8 Registration date Monday February 4, 2013 Status Member Last seen February 11, 2013 - Feb 6, 2013 at 06:31 AM
Hello,

My question is about EXCEl Sheet.

If the cell B2 is equal to any value (numbers/text) then cell A2 = (A1 + 1) if not then keep it Blank (No value or space).

Waiting for a reply...

Thanks,
Dushyant.
Related:

2 responses

Answer 1 / 2
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 5, 2013 at 10:02 AM
Hi Dushyant,

Put this formula in Cell A2 of your sheet:

=IF(B1<>"",A1+1,"")

Check if this gives you the desired values in Cells.

Do reply with results.
1
Answer 2 / 2
dush09 Posts 8 Registration date Monday February 4, 2013 Status Member Last seen February 11, 2013 3
Feb 6, 2013 at 06:31 AM
Hey Zohaib,

Thanks a Lot man It it working as per the question !!!

Thanks and Regards,
Dushyant
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response