Jenniibean
New Member
- Joined
- Dec 7, 2018
- Messages
- 4
Current formula is =A1*B1 and in C1 is the total. A1 contains a number and B1 contains the word "included" but sometimes it is a number value and not text. I formatted column B as a number so the formula was calculating the word "included" as a number but now it has stopped and it's giving me the #VALUE ! error. Tried an example below of what all needs to be calculated.
HELP!
<tbody>
</tbody>
HELP!
5 | included | =A1*B1 |
5 | 2,000 | =A1*B1 |
<tbody>
</tbody>