Help me understand IF And formula

=IF('Total imports'!F36>3000,'Total imports'!F36,(IF((AND('Total imports'!F36>0.1,'Total imports'!F36<=3000)),3000,0)))

If you break it down, it says:

If Cell F36 on Sheet Total Imports is greater than 3000, then show the data in cell F36. Otherwise, if F36 is greater than 0.1 AND less than or equal to 3000, then show 3000. Otherwise, if all conditions are false, show 0.

Hope that helps.

- Moo

Originally Posted by Moo the Dog

If you break it down, it says:

If Cell F36 on Sheet Total Imports is greater than 3000, then show the data in cell F36. Otherwise, if F36 is greater than 0.1 AND less than or equal to 3000, then show 3000. Otherwise, if all conditions are false, show 0.

Hope that helps.

- Moo

yeap absolutely understood.Thanks mate.Cheers!!!!!

Originally Posted by JBeaucaire

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

thanks.cheers!!!