#### rbpd5015

##### New Member
Ok guys I got one last question, that needs help

I have a if formula as below
=IFERROR(IF(C7=1,B\$2,IF(C7=2,B\$2+B\$3+G6,IF(C7=3,B\$2+B\$3+B\$4+F5+G6,IF(C7=4,B\$2+B\$3+B\$4+F4+F5+G6,"")

Now this works perfect, but I want to make a change and need help.

Instead of tracking just one thing I need it to track to

For example my formula says IF C7= 1,2,3,4

Now I got B7 also 1,2,3,4,5 and each 1-5 has a c7 of 1-4?

SO I need to change my formula

You guys understand? I am almost confused.

MAtt

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Anthony47

##### Well-known Member
rbpd5015 said:
I am almost confused

Me too...
What do you need to do, based on the contents of C7 and B7??

Bye.

Replies
7
Views
202
Replies
5
Views
216
Replies
7
Views
1K
Replies
6
Views
662
Replies
1
Views
285

1,191,122
Messages
5,984,773
Members
439,910
Latest member
Flyingjoblo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back