simplify a large formula
"T. Valko" wrote:
Try this:
=((C13<0)*AC1+(D13<0)*AC2+(F13<0)*AC2)*SUM(COUN TIF(N13:Y13,{"p","m"}))
--
Biff
Microsoft Excel MVP
greate works!! now this one
=IF(F13=0,0,35)+IF(F14=0,0,35)+IF(F15=0,0,35)+IF(F 16=0,0,35)+IF(F17=0,0,35)+IF(F18=0,0,35)+IF(F19=0, 0,35)+IF(F20=0,0,35)+IF(F21=0,0,35)+IF(F22=0,0,35) +IF(F23=0,0,35)
|