I'm trying to multiply the first number by the second number in a cell that has a "d" between them. Sometimes the number has more than a single number.
for instance
2d6 would = 12
12d8 would =96
dealing with a concatenate function to add text before the formula
(e.g.) CONCATENATE("final damage ",SUM(Cell 1, Cell 2, and whatever function to figure out what is needed for the math))
Bookmarks