Help With Formula Please

[rbpd5015]

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

 

[Anthony47]

I am almost confused

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

Bye.