HI I need help with solving this problem. In cell I5, enter an AND IF function that enters F5*.10 if the value in the Program range is English AND the value in the Level range is 1. If neither of these criteria are met, nothing is entered. You should see FALSE in cell I5 and $200 in cell I7. please replay back to me as soon as possible.
Last edited by se7en2001; 05-07-2016 at 04:44 PM.
your request is rather vague. In general an IF AND statement goes something like this... =IF(AND(condition1,condition2,etc or end here),do this,else do that) So if you want to look at A2=english and B2=1 then take F5 times .1 or make it false and I'm not sure how I7 factors in, that might be a different formula as you can't have a formula that affects a different cell, only the cell it is in. So, =IF(AND(A2="english",B2=1),F5*.1,FALSE) might work. Then maybe in I7 you put something like ...=IF(I5=FALSE,200,"") and format as currency.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This is a total guess, based on what I think you want...
=IF(and(B2="english",C2=1),F5*0.1,"")
I have no idea what that means?You should see FALSE in cell I5 and $200 in cell I7. please replay back to me as soon as possible.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That is the result you should see if you do it right.
I am still having trouble with this problem and i typed in the right formula but it only shows the I4 and I17. I can send you tile file to see if someone can help me. thank youHwangbo_StudentAccounting.xlsx
Why is I4 looking in rows 5 and 6 for the AND() conditions? Shouldn't it be looking in row 4?
Originally Posted by shg
because my homework assignment was to enter it in I5
Hwangbo_StudentAccounting.xlsx
Here is the one that is updated.
You made some errors in entering the formula. The formula in I5 should be
Formula:
Please Login or Register to view this content.
I don't know why I5 was chosen but I4 should be
Formula:Please Login or Register to view this content.
Here is your workbook with the corrected formula
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you SO much for help~
If you want the result to be FALSE you can just omit the FALSE argument as it will default to FALSE.
=IF(AND(D5="english",E5=1),F5*0.1)
=IF(AND(D4="english",E4=1),F4*0.1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks