Insert Formula

[zplugger]

Is this possible

if D21 has value then the code in E21 =SUM(C21-D21)*(MATCH(B21,$AC$25:$AC$44,0)*5)

. So if D21 has no vale then no code in E21,if D21 has value then the code runs ?

Thanks z


Have a cross post too.
formula returns wrong result

 

[Skybluekid]

=if(d21="","",sum(c21-d21)*(match(b21,$ac$25:$ac$44,0)*5))

 

[zplugger]

Thanks Skybluekid
Works like a charm, will add code too my notebook for future.
Z

 

[Skybluekid]

You are very welcome