Round with IF's
 

I figured out a formula (below) but then realized that I needed to round the
numbers to two decimals so I tried to add Round into it (which I've never
used before). It seems to work except that now the cells that do not have a
number in them are showing a #Value error. Can someone please tell me what I
am missing? Here's what I have

=ROUND(IF(D24="","",IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24))),2)

Thanks in advance. I'm very new to Excell and I'm really enjoying learning
it but I think I might have given up a long time ago without this website.

Round with IF's
 

Try this:
=IF(D24="","",ROUND(IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24)),2))

--

Rodrigo Ferreira


"Klee" escreveu na mensagem
...
I figured out a formula (below) but then realized that I needed to round
the
numbers to two decimals so I tried to add Round into it (which I've never
used before). It seems to work except that now the cells that do not have
a
number in them are showing a #Value error. Can someone please tell me what
I
am missing? Here's what I have

=ROUND(IF(D24="","",IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24))),2)

Thanks in advance. I'm very new to Excell and I'm really enjoying learning
it but I think I might have given up a long time ago without this website.

Round with IF's
 

try:

=IF(D24="","",IF(E24="",ROUND(D24-F24,2),IF(E24=0,ROUND(D24-F24,2),ROUND(D24*E24-F24,2))))

"Klee" wrote:

I figured out a formula (below) but then realized that I needed to round the
numbers to two decimals so I tried to add Round into it (which I've never
used before). It seems to work except that now the cells that do not have a
number in them are showing a #Value error. Can someone please tell me what I
am missing? Here's what I have

=ROUND(IF(D24="","",IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24))),2)

Thanks in advance. I'm very new to Excell and I'm really enjoying learning
it but I think I might have given up a long time ago without this website.

Round with IF's
 

Thank you, this is perfect!

"Rodrigo Ferreira" wrote:

Try this:
=IF(D24="","",ROUND(IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24)),2))

--

Rodrigo Ferreira


"Klee" escreveu na mensagem
...
I figured out a formula (below) but then realized that I needed to round
the
numbers to two decimals so I tried to add Round into it (which I've never
used before). It seems to work except that now the cells that do not have
a
number in them are showing a #Value error. Can someone please tell me what
I
am missing? Here's what I have

=ROUND(IF(D24="","",IF(E24="",D24-F24,IF(E24=0,D24-F24,(D24*E24)-F24))),2)

Thanks in advance. I'm very new to Excell and I'm really enjoying learning
it but I think I might have given up a long time ago without this website.