IF FUNCTION in excel
Solved/Closed
bkaromo
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
-
Nov 29, 2012 at 01:54 AM
bkaromo Posts 5 Registration date Thursday November 29, 2012 Status Member Last seen November 30, 2012 - Nov 30, 2012 at 08:15 AM
bkaromo Posts 5 Registration date Thursday November 29, 2012 Status Member Last seen November 30, 2012 - Nov 30, 2012 at 08:15 AM
Related:
- IF FUNCTION in excel
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
- Agp function - Guide
4 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 29, 2012 at 09:06 AM
Nov 29, 2012 at 09:06 AM
Hi bkaromo,
For this you need to use nested IF Function. Enter the below mentioned formula in C5 and check if it gives you results:
=IF(ISNUMBER(SEARCH("016f7",A5)), "The monthly instalment is equivalent to...........",IF(ISNUMBER(SEARCH("016b8",A5)),"The monthly instalment is equivalent to...........",IF(ISNUMBER(SEARCH("017a3",A5)),"The monthly instalment is equivalent to...........","")))
Please revert for clarification.
For this you need to use nested IF Function. Enter the below mentioned formula in C5 and check if it gives you results:
=IF(ISNUMBER(SEARCH("016f7",A5)), "The monthly instalment is equivalent to...........",IF(ISNUMBER(SEARCH("016b8",A5)),"The monthly instalment is equivalent to...........",IF(ISNUMBER(SEARCH("017a3",A5)),"The monthly instalment is equivalent to...........","")))
Please revert for clarification.
bkaromo
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
Nov 29, 2012 at 10:02 AM
Nov 29, 2012 at 10:02 AM
Zohaib R,
My issue is not yet solved. what i wanted is to insert the monthly instalment at the end of the sentence by picking a value from a diffent cell, say "A1", so that
=if(A5="017A3", The monthly instalment is equivalent to "B5","")
when i drag the formula, =if(A6="017A3", The monthly instalment is equivalent to "B6","") and so on and so forth.
My answer is the value in B5,B6,B7.
is it possible?
My issue is not yet solved. what i wanted is to insert the monthly instalment at the end of the sentence by picking a value from a diffent cell, say "A1", so that
=if(A5="017A3", The monthly instalment is equivalent to "B5","")
when i drag the formula, =if(A6="017A3", The monthly instalment is equivalent to "B6","") and so on and so forth.
My answer is the value in B5,B6,B7.
is it possible?
bkaromo
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
Nov 29, 2012 at 10:07 AM
Nov 29, 2012 at 10:07 AM
Thank good people,
I have a long list of customers, and would want a formula to insert their monthly instalments at once.
I have a long list of customers, and would want a formula to insert their monthly instalments at once.
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 29, 2012 at 12:15 PM
Nov 29, 2012 at 12:15 PM
Hi bkaromo,
Use this formula instead:
=IF(A5="016f7", "The monthly instalment is equivalent to " & B5,IF(A5="016b8","The monthly instalment is equivalent to " & B5,IF(A5="017a3","The monthly instalment is equivalent to " & B5,"")))
Do reply with results.
Use this formula instead:
=IF(A5="016f7", "The monthly instalment is equivalent to " & B5,IF(A5="016b8","The monthly instalment is equivalent to " & B5,IF(A5="017a3","The monthly instalment is equivalent to " & B5,"")))
Do reply with results.
bkaromo
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
Nov 30, 2012 at 08:15 AM
Nov 30, 2012 at 08:15 AM
Hi Zohaib R,
Thank you, thank you, thank you very much.
This has worked like magic.
Keep the good work.
Thank you, thank you, thank you very much.
This has worked like magic.
Keep the good work.
