In this paper, the classical least square (CLS) method with molecular absorption spectrophotometric measurement was used to determine simultaneously of paracetamol (PAR), ibuprofen (IBU), and caffeine (CAF) in tablets. The absorbance spectra of the standard solutions and samples were measured over a wavelength from 220 to 300 nm with a 0.5 nm step. The concentration of PAR, IBU and CAF in the sample solutions were calculated by using a program called CLS-Excel written in Microsoft Excel 2016 and Visual Basic for Applications (VBA). The method and CLS-Excel program were tested on mixed standard laboratory samples with different PAR, IBU, and CAF concentration ratios, and they showed small errors and satisfying repeatability. An analytical procedure for tablets containing PAR, IBU, and CAF was developed. The reliability of the procedure was proved via the recovery and repeatability of the analysis results with an actual tablet sample and comparing the mean contents of active substances in the tablets obtained from the analytical procedure with the from the HPLC method. The procedure is simple with a reduced cost compared with the HPLC standard method.