Microsoft Office Forums - View Single Post - Insert cap figure instead of sum

Thread: Insert cap figure instead of sum

View Single Post

Old

08-09-2018, 01:56 PM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

What about?

=MIN(C7,SUM(L7,O7))

Reply With Quote