I need set up a formula so that if the answer is not a whole number, an error
message will show. Thank you.
I need set up a formula so that if the answer is not a whole number, an error
message will show. Thank you.
Let's say we are interested in =A1/A2 being an integer, use:
=IF(INT(A1/A2)*A2=A1,A1/A2,"ERROR")
so if A1 is 12 and A2 is 6 you will see 2
if A1 is 13 and A2 is 6 you will see ERROR
The general form is :
=IF(INT(A1)=A1,A1,"ERROR")
--
Gary's Student
"TriFiV" wrote:
> I need set up a formula so that if the answer is not a whole number, an error
> message will show. Thank you.
"TriFiV" <[email protected]> wrote in message
news:[email protected]...
>I need set up a formula so that if the answer is not a whole number, an
>error
> message will show. Thank you.
=IF(MOD(your formula,1)=0,your formula, "Error")
--
David Biddulph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks