| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
| Conditional formatting in a data table | Excel Discussion (Misc queries) | |||
| Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
| Cell formatting when importing data | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Linear Mode
