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

G

G58

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top