Rounding to 2
 

I am using this formula that works very good because If there is no number it
does not show. But the problem that I have right now is that the formula
needs to round to 2 spaces. because there other formulas that calculate the
total base on this one.

=IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260,U626,1) ,"") I try to do:
=Round(=IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260, U626,1),""),2) but I get
the word "Value"


Thanks

Frances

Rounding to 2
 

One way:

=IF(COUNT(K626,Q626),"",ROUND(K626*Q626*IF(U6260, U626,1),2))

In article ,
Frances C wrote:

I am using this formula that works very good because If there is no number it
does not show. But the problem that I have right now is that the formula
needs to round to 2 spaces. because there other formulas that calculate the
total base on this one.

=IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260,U626,1) ,"") I try to do:
=Round(=IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260, U626,1),""),2) but I get
the word "Value"


Thanks

Frances

Rounding to 2
 

Delete the '=' before the IF
=Round(IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260,U 626,1),""),2)

Regards,
Ryan--

--
RyGuy


"Frances C" wrote:

I am using this formula that works very good because If there is no number it
does not show. But the problem that I have right now is that the formula
needs to round to 2 spaces. because there other formulas that calculate the
total base on this one.

=IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260,U626,1) ,"") I try to do:
=Round(=IF(COUNT(K626,Q626)=2,K626*Q626*IF(U6260, U626,1),""),2) but I get
the word "Value"


Thanks

Frances