ExcelBanter - multiple formats in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multiple formats in a cell (https://www.excelbanter.com/excel-worksheet-functions/248622-multiple-formats-cell.html)

Gridlock

multiple formats in a cell

I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm struggling
to find a way to do this in Excel 2003. Can you help please?

Ms-Exl-Learner

multiple formats in a cell

Provide some examples about your data and how would you like to get the result€¦

--------------------
(Ms-Exl-Learner)
--------------------

"Gridlock" wrote:

I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm struggling
to find a way to do this in Excel 2003. Can you help please?

Don Guillett

multiple formats in a cell

???
=IF(D4<1,TEXT(D4,"0.00%"),TEXT(D4,"#"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gridlock" wrote in message
...
I'm trying to find a way of displaying the content of a cell as either a
number or a percentage depending on the output from a lookup. I'm
struggling
to find a way to do this in Excel 2003. Can you help please?

All times are GMT +1. The time now is 11:51 AM.