Python code: TypeError: unsupported operand type(s) for *: 'NoneType' and 'float'

hi, I am new to Python at beginner level and following Mr Mosh tutorials.
while I am following Mr Mosh coding a simple project that involves automation that process thousands of spreadsheets in under a second, and do act in accordance with him step by step. Although the codes mine and his are the same but when I run the code I am getting something like:

corrected_price = cell.value * 0.9
TypeError: unsupported operand type(s) for *: ‘NoneType’ and ‘float’

can anyone help me with this part please

have you tried:
corrected_price = float(cell.value) * 0.9

The error indicates that you try to multiply a None type with a float which makes no sense mathematically. perhaps you should check the cell to see if it’s empty.

thanks a lot for your kind replays but still having the same problem despite trying all the answers you gave me

Could you share what your code looks like now and what error you are currently getting?

If you have applied all of the instructions, I assume it would look something like this:

if cell.value:
  corrected_price = cell.value * 0.9
else:
  corrected_price = 0

I assume that the value should be presumed to be 0 if not present, but I do not own the Python course so I am not certain what the behavior should be for an empty cell.