Hi All,

I have a problem that I hoping you guys could help with.

I am trying to create a matrix that consists of cells derived from results of an IF statement. The issue I have is that when the condition is TRUE, I would like the IF statement to return a value formatted in $ (accounting dollars) and for the FALSE condition, I would like the statement to return a custom format. The custom format is nothing but the result (now in %) appended with custom text).

D4 = $36.80
B14 = $1000
C13 = "12 Months"
D13 = "24 Months"
E13 = "36 Months"

The condition looks like this..
=IF($B14/LEFT(C$13,2)>$D$4,$D$4-$B14/LEFT(C$13,2),($B14/LEFT(C$13,2))/$D$4&"% OFF")

And my results look like this (from left to right - and this is the 1st row of the matrix)

$(46.53) $(4.87) 0.754830917874396% OFF

While the numbers are correct, in the last cell, I am unable to format. It should read as 75.48% OFF.

Would appreciate your help.

Thanks much...