error in excel

Highlighted
New Contributor

Dear,

 

I am facing a strange behaviour in excel (office 365).

I am trying to calculate a value but it shows an error as you can see in the attached screen-shot:

=(1-G2)*J6

Can you please advice if this is a bug or if I misstyped the formula ? And how to fix it ?

 

Regards

1 Reply
Highlighted
Please post this on the excel forum also for best chance of response