I have been looking for over an hour online and cant figure it out.
Basically I have an if formula, IF(D5=20,2000,)&IF(D5=16,1500,) and it works fine. However, I want to autosum the results of that column with that formula. Ive learned its in text, but cant convert it, also I would like to make it so if I apply that formula to the rest of the column it will give me a number format, as it will be added.
Thanks in advance
Bookmarks