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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)}.
 
Back
Top