Combine 2 excel formulas to make one formula for a cell

[NVRensburg]

HI there

I currently have this formula in my cell

=IF(SUM(I4:CD4)=0,"",H4*14%)

and I've read a tip regarding rounding for vat to put this formula in

=ROUND(B2*1.14,2).

How do I merge these 2 formulas to work in one cell?

 

[rupertlo]

=round(if(sum(i4:cd4)=0,"",h4*14%),2)

 

[Rickmaurinus]

Hi NVRensburg,

Thanks for posting your question. From your explanation it's not completely clear to me what numbers you have put in which cells.

But if you want to round the part "H4*14%", you could write:

=IF( SUM(I4:CD4)=0,"", ROUND(H4*14%,2))

You can also round the whole "IF" formula as follows:

=ROUND( IF( SUM(I4:CD4)=0, 0, H4*
Please note that I replace the TRUE condition being "", by 0, because excel will give a #VALUE error when you try to round text.

Hope it helps,

Rick

 

[NVRensburg]

Hi NVRensburg,

Thanks for posting your question. From your explanation it's not completely clear to me what numbers you have put in which cells.

But if you want to round the part "H4*14%", you could write:

=IF( SUM(I4:CD4)=0,"", ROUND(H4*14%,2))

You can also round the whole "IF" formula as follows:

=ROUND( IF( SUM(I4:CD4)=0, 0, H4*
Please note that I replace the TRUE condition being "", by 0, because excel will give a #VALUE error when you try to round text.

Hope it helps,

Rick

Thank you that works !

 

[NVRensburg]

Sorry guys, I see the rounding actually needs to be in this cell

=IF(SUM(I4:CD4)=0,"",SUM(I4:CD4))

How would I add the rounding formula to that cell formula?