Joining 2 if functions
 

Hi I tried joining
=IF(($H$2/(D4*F4))=INT($H$2/(D4*F4)),$H$2/(D4*F4),"incorrect size")
with
=if(even(a1)=a1,"even","odd"

by=IF(and($H$2/(D4*F4))=INT($H$2/(D4*F4)),(even(F2)=F2,$H$2/
(D4*F4),"incorrect size")

it returns that too many arguments are being made
please suggest solution
what i really need is to add a at least 1 more argument

Joining 2 if functions
 

I think you meant to do something like this:

=IF(and($H$2/(D4*F4)=INT($H$2/(D4*F4)),even(F2)=F2),$H$2/
(D4*F4),"incorrect size")

Be careful with your brackets.

Hope this helps.

Pete

On Nov 14, 6:31*pm, Richard D
wrote:
Hi I tried joining
=IF(($H$2/(D4*F4))=INT($H$2/(D4*F4)),$H$2/(D4*F4),"incorrect size")
with
=if(even(a1)=a1,"even","odd"

by=IF(and($H$2/(D4*F4))=INT($H$2/(D4*F4)),(even(F2)=F2,$H$2/
(D4*F4),"incorrect size")

it returns that too many arguments are being made
please suggest solution
what i really need is to add a at least 1 more argument

Joining 2 if functions
 

On Nov 14, 11:40*pm, Pete_UK wrote:
I think you meant to do something like this:

=IF(and($H$2/(D4*F4)=INT($H$2/(D4*F4)),even(F2)=F2),$H$2/
(D4*F4),"incorrect size")

Be careful with your brackets.

Hope this helps.

Pete

On Nov 14, 6:31*pm, Richard D
wrote:

Hi I tried joining
=IF(($H$2/(D4*F4))=INT($H$2/(D4*F4)),$H$2/(D4*F4),"incorrect size")
with
=if(even(a1)=a1,"even","odd"

by=IF(and($H$2/(D4*F4))=INT($H$2/(D4*F4)),(even(F2)=F2,$H$2/
(D4*F4),"incorrect size")

it returns that too many arguments are being made
please suggest solution
what i really need is to add a at least 1 more argument



Hey thanks Pete this is magic
to be honest i have no background in writing code
just trying to make a format to ease some of our work processes
and I am amazed at how the WWW works in cases such as these
regards,
richard.