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