formula to show the "<>" symbols

[aboiy]

We've been doing the monthly report showing our expenses
incurred from the previous month.

A B C D E
Budget Expenses Balance % Bal. Status
148,100 126,673.03 21,423.97 < 14.47% Within Budget
(100-b2/a2%)

From the above example, we have to show the remaining
balance in figure in column "C" and the % remaining
including the symbol "<>" in column "D".

My question:
1- Is it possible to include in the formula to show
the "<>" symbol for the result in col."D"
2- The status in column "E" to display the text:
"Within Budget" or "Over Budget" if column B is less
than or greater than column A.

For your kind assitance.

Thanks and regards.

aboiy

 

[Bob Umlas]

How about =IF(A2<B2,"<",">")&(100-b2/a2)&"%"
??

 

[aboiy]

Bob,

Its working! but i dont have control on the decimal
side,its too long. ive tried to decrease it in the decimal
icon but still not changing.

aboiy

 

[aboiy]

Bob,

Its working! but i dont have control on the decimal
side,its too long. ive tried to decrease it in the decimal
icon but still not changing.

aboiy

 

[Bernie Deitrick]

Aboiy,

You can't change the result of the formula through formatting, since the
formula returns a string. And your formula for percentage was wrong, so I've
fixed that.

You can use the TEXT function, along the lines of

=IF(A2<B2,"<",">")&TEXT((1-B2/A2),"0.00%")

Change the "0.00%" to change the format of the returned percentage.

HTH,
Bernie
MS Excel MVP

 

[aboiy]

Bernie,

Great! its okey now.

Thank you so much.

Regards,

aboiy