ExcelBanter - Formula help!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula help! (https://www.excelbanter.com/excel-worksheet-functions/202240-formula-help.html)

nkonfya

Formula help!

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?

Duke Carey

Formula help!

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?

T. Valko

Formula help!

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?

All times are GMT +1. The time now is 06:39 PM.