Formatting data within an equation
 

Hi there

I am trying to format a number within an formula as per below. The cells
both contain numbers (as a result of other formulae and I'd like to format
the answer so that the n50-e50/e50-n50 is a number with only two decimal
places.

=IF(E50<N50,"This will save you £"&(N50-E50)&".","This will save you
£"&(E50-N50)&".")

Any help appreciated.

Thanks

Formatting data within an equation
 

Have a look in help index for TEXT

--
Don Guillett
SalesAid Software

"jonrtait" wrote in message
...
Hi there

I am trying to format a number within an formula as per below. The cells
both contain numbers (as a result of other formulae and I'd like to format
the answer so that the n50-e50/e50-n50 is a number with only two decimal
places.

=IF(E50<N50,"This will save you £"&(N50-E50)&".","This will save you
£"&(E50-N50)&".")

Any help appreciated.

Thanks

Formatting data within an equation
 

One way:

="This will save you " & TEXT(ABS(N50-E50),"£0.00.")



In article ,
"jonrtait" wrote:

Hi there

I am trying to format a number within an formula as per below. The cells
both contain numbers (as a result of other formulae and I'd like to format
the answer so that the n50-e50/e50-n50 is a number with only two decimal
places.

=IF(E50<N50,"This will save you £"&(N50-E50)&".","This will save you
£"&(E50-N50)&".")

Any help appreciated.

Thanks