Numberformat vs string question

  • Thread starter Thread starter Mike_Gator14
  • Start date Start date
M

Mike_Gator14

Hi,

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

If(A1>0;"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
 
Hi
If(A1>0;"Premium due = EUR " & TEXT(A1,"#.#,00");"Premium Return = EUR
" & TEXT(A1,"#.#,00"))
 

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

Help on Echange rare 6
Time Calculations Help 4
A data validation question 1
Problem with code used in other countries 5
Conditional Formatting macro: simple, but doesn't work 6
How to give the numberformat the systemdefault date format? 1
Trying to evaluate cell referenes in a string 3
change event question 3

Back
Top