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

Reply ↓  Report •

✔ Best Answer
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"))

MIKE

http://www.skeptic.com/

message 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?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#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


Reply ↓  Report •

#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.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
October 30, 2018 at 07:12:26
✔ Best Answer
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"))

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#5
October 30, 2018 at 09:05:50

Reply ↓  Report •

Ask Question