Hi,
Not sure whether the price is variable but with the number of users in A1 try
Formula:=MAX(99,99+A1-1000*10%)
If not upload an example workbook and manually enter some example results for differing numbers of users and prices if relevant.
Hi,
Not sure whether the price is variable but with the number of users in A1 try
Formula:=MAX(99,99+A1-1000*10%)
If not upload an example workbook and manually enter some example results for differing numbers of users and prices if relevant.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks