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
Hello,

my formula is =If(or(A5="016f7",A5="016b8",A5="017a3"),The monthly instalment is equivalent to...........,"")

I want in place of ............, to insert a figure in C5.


Kindly help me.
Related:

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
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.
bkaromo Posts 5 Registration date Thursday November 29, 2012 Status Member Last seen November 30, 2012
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?
bkaromo Posts 5 Registration date Thursday November 29, 2012 Status Member Last seen November 30, 2012
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.
0
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
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.
bkaromo Posts 5 Registration date Thursday November 29, 2012 Status Member Last seen November 30, 2012
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.