Thread
:
Formatting data within an equation
View Single Post
#
2
Don Guillett
Posts: n/a
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
Reply With Quote