Remember Me?

#### Menu

#1
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
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
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
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
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
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
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
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
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
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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post laudyhgp Excel Worksheet Functions 1 August 6th 09 11:33 PM Shaggyjh Excel Discussion (Misc queries) 4 April 21st 09 03:37 PM Ed Excel Discussion (Misc queries) 1 March 31st 09 01:34 PM Rob Excel Programming 2 January 26th 07 10:03 PM 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