Camparing two coloumns in excel and copy another cell value
Closed
SP Kumar
Posts
1
Registration date
Friday January 18, 2013
Status
Member
Last seen
January 18, 2013
-
Jan 18, 2013 at 02:01 AM
basri hamid Posts 1 Registration date Friday January 18, 2013 Status Member Last seen January 18, 2013 - Jan 18, 2013 at 06:10 AM
basri hamid Posts 1 Registration date Friday January 18, 2013 Status Member Last seen January 18, 2013 - Jan 18, 2013 at 06:10 AM
Related:
- Camparing two coloumns in excel and copy another cell value
- Number to words in excel - Guide
- Excel send value to another cell - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
1 response
basri hamid
Posts
1
Registration date
Friday January 18, 2013
Status
Member
Last seen
January 18, 2013
Jan 18, 2013 at 06:10 AM
Jan 18, 2013 at 06:10 AM
Hello SP Kumar,
I try to help you. Try to use formula =if(logical_test;value_if_true;value_if_false)
- Type the formula at coloumn C file-2, =if(
- Click coloumn A file-2, than type =
- Click coloumn A file-1, than type ;
- Click coloumn C file-1, than type ;
- Type 0 or value if false, than type )
- Erase $ sign
- Enter
- Copy the formula to other rows
Good luck.
I try to help you. Try to use formula =if(logical_test;value_if_true;value_if_false)
- Type the formula at coloumn C file-2, =if(
- Click coloumn A file-2, than type =
- Click coloumn A file-1, than type ;
- Click coloumn C file-1, than type ;
- Type 0 or value if false, than type )
- Erase $ sign
- Enter
- Copy the formula to other rows
Good luck.
