If statement

[chally3]

Good morning everyone,

I hope someone can helps with this one, I have the following formula(copied down through rows etc) =IF(D2=G2,"ok",IF(D2>G2,"Supplier MPQ higher","Check pack multiple")) to return a simple text answer, but what I wish to modify this (if possible) to show that t if G2 is a direct multiple(no decimal places) of D2 return the text 'MPQ multiple'.

Is this possible?

Thank you all

 

[steve the fish]

Re: If statement help

You can use MOD function eg:

=IF(D2=G2,"ok",IF(D2>G2,"Supplier MPQ higher",IF(MOD(G2,D2)=0,"MPQ Multiple","Check pack multiple")))

 

[chally3]

Re: If statement help

Thank you @stevetheFish Much appreciated