| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i create a divisible formula
I use a xl doc that has numbers in the cells that need to be divisible by 15.
Can i incert a formula that will check the number in B5 and display an error message in F10 if the number in B5 is not divisible by 15. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i create a divisible formula
Tim,
Try this in F10 =AND(B5<"",MOD(B5,15)=0) Mike "Tim" wrote: I use a xl doc that has numbers in the cells that need to be divisible by 15. Can i incert a formula that will check the number in B5 and display an error message in F10 if the number in B5 is not divisible by 15. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i create a divisible formula
Tim,
Insert this formula into F10: =IF(B5/15-INT(B5/15)0,0,1) This will return a 1 or a 0 depending on whether or not it is divisible by 15. You can change the 1 and 0 to any message you would like, just use quotes if it is text. Doug "Mike H" wrote: Tim, Try this in F10 =AND(B5<"",MOD(B5,15)=0) Mike "Tim" wrote: I use a xl doc that has numbers in the cells that need to be divisible by 15. Can i incert a formula that will check the number in B5 and display an error message in F10 if the number in B5 is not divisible by 15. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i create a divisible formula
On Wed, 6 Jan 2010 05:32:01 -0800, Tim
wrote: I use a xl doc that has numbers in the cells that need to be divisible by 15. Can i incert a formula that will check the number in B5 and display an error message in F10 if the number in B5 is not divisible by 15. Try this formula in cell F10: =IF(MOD(B5,15)0,"error message","") Hope this helps / Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sums divisible by 12 | Excel Worksheet Functions | |||
| getting numbers that are divisible by 4 | Excel Worksheet Functions | |||
| Check if Equally Divisible | Excel Worksheet Functions | |||
| need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. | Excel Worksheet Functions | |||
| how do an @if formula to meet criteria where x is divisible by 12 | Excel Worksheet Functions | |||
Hybrid Mode
