excel if statements

I am attempting to create a formula in B6 that considers the following criteria: If SUM B1:B2 <100 then SUM(B1:B3)*28 If SUM B1:B2 >100 then multiply the first 99 hours by $28 and every hour worked thereafter by $32. Then add B3*28. * B1 & B2 are the only hours to be considered regarding <...

Hi I need help with the following table. I'm not sure how to write the formula for the result: My formula is : =IF(AND([@[Case Reason Reason Peanut ]]="True",[@Peanut]="False"),"True",IF([@[Share Contact ]]="False","Peanut")) Case Reason Reason Peanut Peanut Share Contact Result False...

I have a reference chart that has many columns with many rows of information i have created a formula to read the chart and output an answer based on what it reads, but after further review I need the output to have one more stipulation...

Hi, I have a multi page user form that I am using to predict scores for the premier league soccer fixtures each week. Within each page I have 1 fixture made up of a home team and an away team. This data changes week on week depending on the a web import. I want to add two images to each page...

All, I want to thank you in advance for helping me. I just need help creating a custom IF/VLOOKUP string based off of a list table. I will attach the file for an example. It should be pretty straightforward. Once I get past 3 or so IFs combined it starts getting choppy for me. I really do...

Hi, Can you help me with an if statement. Sometimes an enduser name has a / in the name we need to change the / to an _ For example John Doe/ Jane Doe and I need it to be John Doe_Jane Doe. I really do not have any idea how to write this if statement. thanks, Sharon

I hope you can help. I have a couple of formulas that are breaking due to N/A appearing in cells. I was wondering if these N/A could be accommodated in my formulas to still return a numerical result. In the picture below you can see that in Cell C21 there is 'N/A' and in S21 the is the error...

I have values in F column & N column, the values of N column are depend on the F column data. Means there can be more than one value associated in F column with respect to the value of F. For example F2 Bike N2 Honda bike F3 Car N3 Mercedes Car F4 N4 BMW car F5...

I have inherited a formula from an ex-colleague that contains approximately 14 nested IF statements. I have read somewhere today that you cannot use more than 7. I am using Excel 2002 and I would be grateful if someone could tell me how I can adjust the formula to ensure that it works...