Home » Forums » Open Source Learning Center » Question and Answer

IF??

Submitted by suebee68 on 24 May, 2016 - 17:54

If I have a cell that I want to take total from another cell but cap it at 8 so anything greater than 8 shows as 8. How do I do this? tried this but no workie: =AU36,IF(AU36>8,"8")

‹ How to copy rows through to another worksheet based on criteria satisfaction using VBA Link or shortcut from a master file to a new file for each worksheet ›
»