i want to use IF formula
i had enter in A1 cell mubeen
what i need is if A1 =mubeen then i want to pick from a10 and a11 and b12
i want to use IF formula
i had enter in A1 cell mubeen
what i need is if A1 =mubeen then i want to pick from a10 and a11 and b12
Last edited by mubeenff; 12-09-2010 at 04:57 AM.
What do you mean by "pick from a10 and a11 and b12"?
An IF() function delivers one result. You can concatenate several cell values as the result, but somehow I don't think that's what you want.
Please upload a sample Excel file and manually put in your expected outcome.
cheers,
=IF(A1="mubeen",A10&B10&A12)
The above should work ok.
Thanx a lot sir
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Sir,
in same file if its empty its showing FALSE how can i remove it
try
=IF(A1="mubeen",A10&B10&A12,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks