There's no reason I can see to use a TEXT function, because this leaves the
result unusable in future formulas.

Just use =b1/a1-1, and format as Percent

--
Regards,
Fred


"Daniel CHEN" wrote in message
...
Suppose you have A1 = 715, B1 = 750, in C1 (difference) type the following
formula:

=TEXT(B1/A1-1,"0.00%").

You result will be 4.90%.


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Downloand
=================================


"sunderland27" wrote in message
...
What would be the formula if i wanted to find the percentage difference
between to figures. for instance

Jan Feb Diff
715 750 (what would be the formula to find the
difference?)