Formatting data within an equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Your help please in updating a column using Count or an Array Formula 3
SUMIF and a range of dates- ?? 6
"over-lay" one range onto another range so that only blank cells are affected 2
Can't seem to get an answer to this problem. 2
Create list of worksheets and cell values 2
In excel, the formula of a cell * by 5 then - 15 won't calculate . 5
Summing an entire column in Excel 2
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET 6

Back
Top