# nested and statementes

1. ### Dividing Nested IF/AND sum

Hi! I'm still learning to use nested formulas, and I'm trying to divide this particular formulate below by 7, but when I put /7 the output is incorrect (in this case the sum is 24 but the output of when I put /7 I get 20 - which is definitely not right). Please help...
2. ### Nested IF,AND, OR

Hey All, I am trying to nest a function using the following formula IF(OR(AND(AN4>=AM4),J4<=0,K4<=0,),"TRUE","NONE") I am getting a result, but the result is not what I need. I want the formula to read as 'If AN4>=AM4, AND either J4<=0, OR K4<=0, then "TRUE, if not then "NONE".' Any input...
3. ### Nested Formula ??

I have three Columns Type Discount Rate In the type column It is either "Family" or "Single" In the discount column it is either "n/a"= no discount or "edu",or "mil" = 10% discount In the rate column I need a formula that will give me Family= "100" or 10% off = "90" if mil or edu is in the...
4. ### summarize

I need to summarize data from 4 sheets in a workbook into one master sheet within the same workbook. The 4 sheets represent different employees and the data are the accounts they are responsible for spread over 12 months. There's a billed, paid and difference row. The summary sheet needs to...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...