formula to show the "<>" symbols

  • Thread starter Thread starter aboiy
  • Start date Start date
A

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,

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
 
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,

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
 
Back
Top