Im trying to make a net pay budget spread sheet. I have entered the federal tax chart into an excel sheet and income/hours into another sheet. How would i make a formula that would take one cell on sheet1 and parse the second sheet for "if greater than A1 but less than B1, true, display sum of "sheet1!A1" and "sheet2!C1", else, IF greater than A2 but less than B2, sum of "sheet1!A1" and "sheet2!B3", else, ...

message edited by Rhain

You might be able to use a formula known as a Nested IF. If you DAGS for Nested IF you'll get lots of hits, both text based and videos. In your case, it might look something like this:

=IF(AND(C1>A1,C1<B1),SUM(SHEET1!A1,SHEET2!C1),IF(AND(C1>A2,C1<B2),SUM(...Depending on how many conditions you have this could get quite cumbersome. Perhaps with some more details we could offer an alternative method.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

In the example shown, we are using nested IF functionsto assign grades based on a score. The logic for assigning a grade goes like this:

ScoreGrade

0-63 F

64-72 D

73-84 C

85-94 B

95-100 A

To build up a nested IF formula that reflects this logic, we can start by testing to see if the score is below 64. If TRUE, we return "F". If FALSE, we move into the next IF function. This time, we test to see if the score is less than 73. If TRUE, we return "D". If FALSE, we move into yet another IF function. And so on.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History