ExcelBanter - Numberformat vs string question

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Numberformat vs string question (https://www.excelbanter.com/excel-programming/307074-numberformat-vs-string-question.html)

Mike_Gator14

Numberformat vs string question

Hi,

if I have the following formula on a sheet in cell B1:

If(A10;"Premium due = EUR " & A1;"Premium Return = EUR " & A1)

the return in cell B1 will be f.i. Premium due = EUR 1000

How can I get to print another number format/lay out within the
formula, i.e. that the outcome will be:

Premium due = EUR 1.000,00

Thanks, Mike

Frank Kabel

Numberformat vs string question

Hi
If(A10;"Premium due = EUR " & TEXT(A1,"#.#,00");"Premium Return = EUR
" & TEXT(A1,"#.#,00"))

--
Regards
Frank Kabel
Frankfurt, Germany

Mike_Gator14 wrote:
Hi,

if I have the following formula on a sheet in cell B1:

If(A10;"Premium due = EUR " & A1;"Premium Return = EUR " & A1)

the return in cell B1 will be f.i. Premium due = EUR 1000

How can I get to print another number format/lay out within the
formula, i.e. that the outcome will be:

Premium due = EUR 1.000,00

Thanks, Mike

All times are GMT +1. The time now is 09:06 PM.