Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 3rd 16, 10:58 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2016
Posts: 2
Default Need formula to test if cell is a multiple of 28, but not including 28


I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell value is a multiple of 28, but I need for it to exclude 28 itself.

The very simple formula that I use thereafter =(E7/28)*$G$3 works fine. I've tried all kinds of nested if statements and I can't seem to find a solution here.

Any help much appreciated.

Waz'

  #2   Report Post  
Old June 4th 16, 08:31 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Need formula to test if cell is a multiple of 28, but not including 28

I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell
value is a multiple of 28, but I need for it to exclude 28 itself.

The very simple formula that I use thereafter =(E7/28)*$G$3 works
fine. I've tried all kinds of nested if statements and I can't seem
to find a solution here.

Any help much appreciated.

Waz'


Try...

IF(MOD(G3-28,28)=0,<then it's a multiple,<else it's not a multiple)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

  #3   Report Post  
Old June 4th 16, 08:49 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,853
Default Need formula to test if cell is a multiple of 28, but not including 28

Hi Garry,

Am Sat, 04 Jun 2016 03:31:12 -0400 schrieb GS:

IF(MOD(G3-28,28)=0,<then it's a multiple,<else it's not a multiple)


Mod(0,28) is 0 too
Try:
=AND(G3<28,MOD(G3,28)=0)


Regards
Claus B.
--
Windows10
Office 2016
  #4   Report Post  
Old June 4th 16, 12:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Need formula to test if cell is a multiple of 28, but not including 28

Hi Garry,

Am Sat, 04 Jun 2016 03:31:12 -0400 schrieb GS:

IF(MOD(G3-28,28)=0,<then it's a multiple,<else it's not a
multiple)


Mod(0,28) is 0 too
Try:
=AND(G3<28,MOD(G3,28)=0)


Regards
Claus B.


OR?...
IF(G328,IF(MOD(G3,28)=0,<THEN,<ELSE),<ELSE?)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

  #5   Report Post  
Old June 10th 16, 09:38 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2016
Posts: 2
Default Need formula to test if cell is a multiple of 28, but notincluding 28

On Friday, 3 June 2016 15:59:00 UTC-6, Wazzel wrote:
I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell value is a multiple of 28, but I need for it to exclude 28 itself.

The very simple formula that I use thereafter =(E7/28)*$G$3 works fine. I've tried all kinds of nested if statements and I can't seem to find a solution here.

Any help much appreciated.

Waz'


Thanks so very much! It worked perfectly.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula not including a cell laudyhgp Excel Worksheet Functions 1 August 6th 09 11:33 PM
Cell including text and multiple formulas? Shaggyjh Excel Discussion (Misc queries) 4 April 21st 09 03:37 PM
How do I select numbers for a formula from a cell including text? Ed Excel Discussion (Misc queries) 1 March 31st 09 01:34 PM
Link to Multiple Cells Within One Cell Including Text Rob Excel Programming 2 January 26th 07 10:03 PM
Including a range of number in a IF (Logical Test) formula Zakhary Excel Worksheet Functions 5 December 30th 06 10:07 PM


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017