excel help.how do i display a true value for a cell that displays an integer?

Question

for example, if cell a1 displays any number, i want cell a2 to display the word "true". or else it displays "false" how do i do that?

Answer 1

The appropriate formula for Excel is:

=IF(ISNUMBER(A1) = TRUE,TRUE,FALSE)

Good luck!

Answer 2

To find out if it is just a number then enter into A2:

=ISNUMBER(A1)

To find out if it is an integer:

=IF(ISNUMBER(A1)=TRUE,
IF(MOD(A1,1)=0,TRUE,FALSE))

The second one I had to continue onto the 2nd line. So combine lines one and two into one formula.

You need to run ISNUMBER first before you use MOD otherwise you get an error if A1 is text. The second equation evaluates if it is a number. Then if it is a number it evaluates if it is an integer. If it is not a number it returns FALSE. If it is not an integer it also returns false. It only returns true if it is an integer.

There is another way to write the 2nd formula:

=IF(AND(ISNUMBER(A1)=TRUE, MOD(A1,1)=0),TRUE, FALSE)

bsah is pretty close but his formula is a little more complex than it needs to be.

Answer 3

if you're looking specifically for an integer, as your question title suggests, then some error trapping is necessary and try:

=IF(ISNUMBER(A1),
IF(INT(A1)=A1,TRUE,FALSE),
FALSE)

(line breaks added so the whole thing appears at once)

if you're just looking for any real number, as your explanation suggests ("if cell a1 displays any number"), then make the formula

=ISNUMBER(A1)

obviously the second formula is more simple but may not do exactly what you're looking for.

in wayfstr's formulas, you could change "ISNUMBER(A1)=TRUE" to "ISNUMBER(A1)" because the ISNUMBER function returns true or false for you and you don't have to check if it is equal to true. but basically they're the same formulas, going at the answer from two different sides.

Answer 4

erm... properly u no the final container the place you like the fee of the different 2- variety this in- =sum( then click on between the boxes then placed a sort of warning signs / = divide * = circumstances - = takeaway/minus + = plus/upload then click the different container u choose to put in then close bracket ) then press enter then you definately've your very final fee her is an occasion to make it consumer-friendly =sum(D12*E9) it quite is presented which you're doing sums even with the shown fact that so i cant assist you out with something sorry thats all i understand

Answer 5

I would suggest using one of the following formulas:

= IF(A1=1,TRUE,FALSE) to return the logical values.

= IF(A1=1,"true","false") to return the text in lower case.

Note: If the double quote marks (") are omitted the the text values true and false will be converted to the logical values.

Answer 6

If what you want is to have the word "True" if A1 contains an integer================================

Type this formula in A2.

=IF (MOD(A1,1)=0, "True", "False")

If A1 is an integer , the formula will return "True".

Answer 7

What you want is called conditional formatting.

Select the box you want to affect (in this case a2) then right click and select "conditional formatting" from the drop down.

Then set your options
Then
Sit back and admire your work
Then
Completely forget about this question and let it go to a vote to have best answer awarded so giving it to the answer that is first on the list even though it doesn't answer your question.

Answer 8

I don't know what you mean by "true value" but you can specify the number of decimals by selecting the cell, click on "format" on the menu bar and click "format cells" on the dialog box click on the "number" tab and then "number" category and there you can select decimals that will be shown