2 ways

=((a1+b1)6)*f(a1+b1)

=if((a1+b1)6,f(a1+b1),value if a1+b1<=6)



"nkonfya" wrote:

I need to figure out how to solve the following situation:

A B C
1 4
2 5 f(7)
3 6 f(9)

If Ax+Bx6 then plug that number into a function desgnated for column C. How
do I set this up?