Hello Forum Users,
I recently (yesterday) had someone assist with setting up an array formula using data I have listed in a table (which is fantastic!!).
However I am wondering how I can incorporate min formula into is as my criteria needs based on three (3) or four (4) different limit(s)
e.g Person 1 gets 60% back up-to the person &/or family limits (which (after entering the date via the form data entry box) listed in cells H24 & H25)
e.g person 1 gets 75% of the cost, if the result is more than 75%, then up-to a maximum of $98.00 (the last person who created the array formula appears to have missed this part of the formula)
I also want to create a form entry box to enter the fields into & then this data entry goes directly into the range of cells H23:H90 (instead of having to scroll down the page & enter them in (the totals), I can enter them into this form entry box & the data is copied/entered into the applicable cells
I would like to have the box near the clear contents & copy contents boxes
Thank you
Bookmarks