Skip navigation

How to change a value in a cell and get a different answer?

264 Views 5 Replies Latest reply: Mar 5, 2013 2:25 PM by Jerrold Green1 RSS
altv Calculating status...
Currently Being Moderated
Mar 5, 2013 8:40 AM

I have a Table set up in Numbers which is a simple spreadsheet. In one of the cells, I have a number that depends in another cell. At the moment I have a formula in a cell that is =IF(E8<=255,E8*1%). That works fine if the figure in E8 is less than or equal to 255, but I need to add to that formula something like =IF(E8>=255,E*5%). In other words, E8 can change from the 255 base I am using up or down which will attract a different %age rate.

 

Thanks

 

altv

iMac (21.5-inch Mid 2011), OS X Mountain Lion

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.