98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Minus or Multiplication sign before True or False | Excel forum
Minus or Multiplication sign before True or False | Excel forum
Resolved · High Priority · Version 2003
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |
