Main problem merely by mattwell7790: Can anyone simplify this excel formula?
I came up with this formula for excel. Can any one simplify this?
=(IF(B7=”-”,0,1)+IF(C7=”-”,0,1)+IF(D7=”-”,0,1)+IF(E7=”-”,0,1)+
IF(F7=”-”,0,1)+IF(G7=”-”,0,1)+IF(H7=”-”,0,1)+IF(I7=”-”,0,1)+
IF(J7=”-”,0,1)+IF(K7=”-”,0,1)+IF(L7=”-”,0,1)+IF(M7=”-”,0,1))*E15
It is information about Can anyone simplify this excel formula? that you’ll need to fix conditions with their. With some luck this helps in many ways: and also make the way you live far better. Hoping information about Can anyone simplify this excel formula? may very well be a simple solution in time.
Best answer:
Answer by danuitti
It sure looks like Yahoo! Answers simplified it for you.
You see, you have to add some spaces in the formula, so Yahoo! Answers doesn’t chop things off. After each grouping, just insert a space.
Good luck and Happy Computing!
Answer by Chaminda
What this formula does is it counts the number of cells that don’t have “-” sign in the range B7:M7 and then multiply the answer by E15.
Instead of this long formula, you can use “COUNTIF” function.
=COUNTIF(B7:M7,”-”)*E15
Edit============>
Steve B is right . The formula should be
=COUNTIF(B7:M7,”-”)*E15
Answer by Steve B
=COUNTIF(B7:M7,”-”) * E15
Understand or know good?
Add your personal answer while in the comments!
in this we take a look at my rig update,reasons I have not been able to upload hunting material is my video cards one melted down.so the next three will be u…
People excel formula can be simplified?
No comments:
Post a Comment