# Solved Combining 2 IF statements

October 27, 2018 at 08:48:07
Specs: Windows 7
 I have these 2 IF statements in 2 seperate cells and would like to make them function in one cell. I have tried a few ways of combining but cannot make it work. Can an IF statement expert help me combine these 2?=IF(K21<0.01,("DTI Ratio Available "&TEXT(K21*-1,"\$ 0.00")),("DTI Ratio Short by "&TEXT(K21,"\$ 0.00")))=IF(K20<0.01,"Housing Ratio Available "&TEXT(K20*-1,"\$ 0.00"),"Housing Ratio Short by "&TEXT(K20,"\$ 0.00"))Thank you very very much

See More: Combining 2 IF statements

October 30, 2018 at 07:12:26
 Here is a shorter version:=IF(K21<0.01,("DTI Ratio Available "&TEXT(K21*-1,"\$ 0.00")),("DTI Ratio Short by "&TEXT(K21,"\$ 0.00")))&IF(K20<0.01," Housing Ratio Available "&TEXT(K20*-1,"\$ 0.00")," Housing Ratio Short by "&TEXT(K20,"\$ 0.00"))MIKEmessage edited by mmcconaghy

#1
October 27, 2018 at 10:56:55
 It is not clear what you are trying to accomplish by combining them.It looks like you have this:IF K21 < 0.01 then return A, IF not return B.IF K20 < 0.01 then return C, IF not return D.2 different IF functions, each returning 1 of 2 values that are specific to that IF. There is no apparent connection between the 2 IF's.Let's say that both K20 and K21 are < 0.01. In that situation you would asking the combined formulas to return both A & C in the same cell. In other cases, you'd be asking for A & D, or B & C, etc.Is that what you are trying to do? Return both the DTI Ratio string and Housing Ratio string in the same cell?

#2
October 30, 2018 at 05:09:40
 I realized it was a counterintuitive question about a day after i posted it, so please disregard.But in any case a user from the stackoverflow forum gave me this formula that worked well. I may rearrange my project to incorporate:=CONCATENATE( IF(K21<0.01,("DTI Ratio Available "&TEXT(K21*-1,"\$ 0.00")),("DTI Ratio Short by "&TEXT(K21,"\$ 0.00"))), " ", IF(K20<0.01,"Housing Ratio Available "&TEXT(K20*-1,"\$ 0.00"),"Housing Ratio Short by "&TEXT(K20,"\$ 0.00")) )message edited by mecerrato

#3
October 30, 2018 at 07:05:50
 That is what I was going to suggest, but I would add a comma along with the space between the 2 strings.

Related Solutions

#4
October 30, 2018 at 07:12:26