Solved how to creat a formula in excel

July 2, 2016 at 06:47:58
Specs: Windows 8.1
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


See More: how to creat a formula in excel

Report •


#1
July 3, 2016 at 04:29:27
✔ Best Answer
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.


Report •

#2
July 3, 2016 at 23:24:18
In the example shown, we are using nested IF functions to assign grades based on a score. The logic for assigning a grade goes like this:

Score Grade
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.


Report •
Related Solutions


Ask Question