Thread
:
Help with formula...please
View Single Post
#
6
Harlan Grove
Posts: n/a
Dana DeLouis wrote...
This just uses 1 Min function:
=MIN(12000+0.02*A1,2000+0.04*A1,0.06*A1)
....
Why refer to A1 3 times?
=MIN({12000,2000,0}+{0.02,0.04,0.06}*A1)
Reply With Quote