Help, I know there is a simple way...

  • Thread starter Thread starter Yuccalab
  • Start date Start date
Y

Yuccalab

Hello:

I am trying to calculate an expression using the sumif formula and nee
a little help.

The first parameter of my formula takes the number in cell J2
multiplies by 3.5% and then adds .3 to that figure.

=SUM(J2*3.5%, 0.3)

Now, I want to add a paramter that states, IF cell K2>0, THEN complet
the equation above.

I have tried, a simple SUMIF statement combining the two, but I can'
seem to get it to work.

Thanks for the help!

-fuctionally challenge
 
=IF(K2>0,J2*3.5%+0.3,???)

Replace ??? with whatever you want it to do if K2<=0. If nothing, then perhaps

=IF(K2>0,J2*3.5%+0.3,"")
 
Back
Top