If a cell = TRUE how do I get the cell to do a sum function
 

Im trying to do a conditional:
This is the end result Im looking for.

If cell (F1) has a text match for = CA
Then I want cell (L1) to =SUM(I1*.0875)

I have tried IF and ISTEXT
But I need it perform another formula instead of a true false or text response

If a cell = TRUE how do I get the cell to do a sum function
 

=IF(F1="CA",I1*0.0875,"NA")

MH

"Mark" wrote in message
...
I'm trying to do a conditional:
This is the end result I'm looking for.

If cell (F1) has a text match for = CA
Then I want cell (L1) to =SUM(I1*.0875)

I have tried IF and ISTEXT
But I need it perform another formula instead of a true false or text
response

If a cell = TRUE how do I get the cell to do a sum function
 

=IF(F1="CA",I1*8.75%,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mark" wrote in message
...
I'm trying to do a conditional:
This is the end result I'm looking for.

If cell (F1) has a text match for = CA
Then I want cell (L1) to =SUM(I1*.0875)

I have tried IF and ISTEXT
But I need it perform another formula instead of a true false or text
response

If a cell = TRUE how do I get the cell to do a sum function
 

Try one of these:

=(F1="CA")*(I1*0.0875)

=IF(F1="CA",I1*0.0875,0)

Biff

"Mark" wrote in message
...
I'm trying to do a conditional:
This is the end result I'm looking for.

If cell (F1) has a text match for = CA
Then I want cell (L1) to =SUM(I1*.0875)

I have tried IF and ISTEXT
But I need it perform another formula instead of a true false or text
response

If a cell = TRUE how do I get the cell to do a sum function
 

Thank you both very much!!!

"Bob Phillips" wrote:

=IF(F1="CA",I1*8.75%,"")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mark" wrote in message
...
I'm trying to do a conditional:
This is the end result I'm looking for.

If cell (F1) has a text match for = CA
Then I want cell (L1) to =SUM(I1*.0875)

I have tried IF and ISTEXT
But I need it perform another formula instead of a true false or text
response