Make array formulay to round a number then subtract 10 from it
 

How do I create an array formula to round a number to two digits behind the
decimal point, then subtract 10 from the same number? I have a number in D2
that I want to round and subtract from it and have the results placed in F2.
When I created an array formula, I got a FALSE statement returned. Here is
how I wrote it: {=ROUND(D2, 2)=SUM(D2-10)}.

Make array formulay to round a number then subtract 10 from it
 

try, without array,
=round(d2,2)-10

--
Don Guillett
SalesAid Software

"G58" wrote in message
...
How do I create an array formula to round a number to two digits behind
the
decimal point, then subtract 10 from the same number? I have a number in
D2
that I want to round and subtract from it and have the results placed in
F2.
When I created an array formula, I got a FALSE statement returned. Here
is
how I wrote it: {=ROUND(D2, 2)=SUM(D2-10)}.