Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

functions

ResolvedVersion 2003

Carlos has attended:
Excel Intermediate course
Excel Advanced course

Functions

how do I enter a @round formula when the cell already has a IF formula

RE: functions

Hi Carlos

Thank you for your question.

You can nest functions together for example =if(A1<1,ROUND(A1,1),A1)

If the value of A1 is very small (less than 1) round it to one decimal place otherwise just show the value in A1

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.07 secs.