IF FUNCTION in excel

[Solved/Closed]
Report
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
-
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
-
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.

4 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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.
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012

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

Thank good people,


I have a long list of customers, and would want a formula to insert their monthly instalments at once.
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
45
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.
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012

Hi Zohaib R,

Thank you, thank you, thank you very much.
This has worked like magic.


Keep the good work.