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?

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?

Maybe this:

=IF(A1+B16,A1+B1,"")

Copied down

--
Biff
Microsoft Excel MVP


"nkonfya" wrote in message
...
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?