IF and Round

A

Annie

Hi I was wondering if there was a function that could round up or down based
on an IF formula.

What I have are Euro prices and Sterling prices in my spreadsheet. I have a
little formula that will calculate the Euro price from the Sterling price but
I am getting decimal places with cents. We do not deal with cents so I need
to use a formula so that if the calculation in the cell is showing with the
decimal fractions that it will round up or down to the nearest euro. Would
this be an =IF(ROUND( formula or would it be a format on the cell after the
formula returns an answer.

Many thanks

Ann
 
S

Stefi

You don't need if!
=ROUND(yourformula,0)

does the job.

Regards,
Stefi

„Annie†ezt írta:
 

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

Rounding cents 3
IF formula for currency or Macro help. 0
Need formula to round number up to always end in X.X9 6
Round Function 5
CAN I ROUND TO THE NEAREST # ENDING IN 99 FOR EXAMPLE 8
Round Question 3
I need a %age increase formula that rounds up to the nearest $10 4
Calculate to the third decimal and round up or down in cell 6

Top