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

G

Guest

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
 
B

Bob Phillips

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

--
HTH

Bob

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

Guest

Thank you both very much!!!

Bob Phillips said:
=IF(F1="CA",I1*8.75%,"")

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISTEXT TRUE then copy formula from cell X 7
How to set cell value to emptry if three other columns are empty too 1
Difficulty with Sum+IF Function 10
IF Cell A1 = Home, Cell A2 should change to 123 3
If Statement to subtract “time†if condition met 7
Last cell used in SUM IF formula 4
Can getpivotdata use a cell reference? 5
Need Help with Excel and Flagging Outcomes! 4

Top