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
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