Thread: [Solved] maximum total
View Single Post
 
Old 01-04-2018, 06:51 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try:

In E7:

=MIN(40,D7*1.5)

in G7:

=E7-F7

in H7:

=MAX(0,D7*1.5-40)
Reply With Quote