View Single Post
  #1   Report Post  
jonrtait
 
Posts: n/a
Default 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