Donate SIGN UP

Mac Numbers If And Round Function In Same Formula

Avatar Image
camioneur | 06:41 Tue 03rd Jan 2017 | Technology
10 Answers
Can anyone help?

Is it possible to use the "IF" and "ROUND" functions in the same formula in Apple Numbers but I'm unable to find any help on this subject

I would like to use the "Round" function to limit the result to 2 decimal places (actual, not just visible) of a formula produced by an IF function in the same cell. I hope this makes sense to someone!
Gravatar

Answers

1 to 10 of 10rss feed

Avatar Image
Hopefully this will link to a screenshot of the formula on my iPad, I haven't used full Numbers on the Mac as I have Excel https://www.flickr.com/gp/21543267@N05/sKdwk4
09:20 Tue 03rd Jan 2017
I don't see why not. See the example answer given here:

https://discussions.apple.com/thread/1493917?start=0&;tstart=0
-- answer removed --
-- answer removed --
Question Author
Thanks Slide-Rule but that thread doesn't seem to work for me..
My formula for A2 is.. IF(D4>1,A4×0.2,"")
If A4 = 405.53 the answer visible is 81.11 when formatted to 2 decimal places or 81.060 when formatted to 3. Formatting doesn't effect the actual result, just the visible result . I need the actual answer to be 81.11 regardless of format in cell A2 or the auto sum function for column 2 is wrong by 0.1
=if(d4greater than 1,round(a4x0.2,2),"")
The 2 after the *0.2 is the number of decimal places to round to, I've only tried this on Numbers on the iPad but it seems to do what you want
-- answer removed --
Question Author
Thanks Fitzer but I'm getting a red triangle.. The formula contains a list where a single argument is expected.
Hopefully this will link to a screenshot of the formula on my iPad, I haven't used full Numbers on the Mac as I have Excel https://www.flickr.com/gp/21543267@N05/sKdwk4
Question Author
Fitzer you've sorted it thanks. Your iPad formula (without brackets) works a treat. I was putting too many brackets in. Murdo thanks for your efforts but you clearly operate on a different level to me and didn't really understand how to apply your theory to my context. Thanks to you both anyway, much appreciated

1 to 10 of 10rss feed

Do you know the answer?

Mac Numbers If And Round Function In Same Formula

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.