Hello guys can you help me Im new on using the excel as for it i was trying to make a simulation of likes of baccarat card games which will have cards value and Im making a computation for excel on it is there a way i can declare value of 10 to 0. As for the result from the column F it auto sum the values from column B and D same from column G it auto sum the values from column C and E. I just want to limit the sum, which will give me results from 0 to 9 only even for sample the value of 2 cells will sum up 10, 20, 30 it will result to 0 and if it is 11, 21 it will only result 1 which will be only in one digit.
Thank You very much.
Bookmarks