Tue 14 Oct 2008, 10:35Delegate Angela said...
Angela has attended:
Excel VBA Intro Intermediate course
Minus or Multiplication sign before True or False
Hi
I just came across a formula in a spreadsheet that I have to update
=OR(A48-TRUE,A49=TRUE,A50=TRUE)
I don't understand what the minus sign before 'TRUE' means.
I have also come across formulas with * before TRUE.
Grateful for your help on this.
Many thanks
Thu 23 Oct 2008, 17:28Trainer Laura said...
RE: Minus or Multiplication sign before True or False
Hi Angela
Thank you for the question.
If you use TRUE in a calculation it is treated as a 1, so multiplying by TRUE I can see no reason for. As for your calculation with the OR it reduces A48 by one. If A48 contained False or True then A48-True would reverse the value, or its the same as A48=FALSE.
I hope that helps
Laura GB
