LinkBack URL
About LinkBacks
=IF('Total imports'!F36>3000,'Total imports'!F36,(IF((AND('Total imports'!F36>0.1,'Total imports'!F36<=3000)),3000,0)))
=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
yeap absolutely understood.Thanks mate.Cheers!!!!!Originally Posted by Moo the Dog
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
thanks.cheers!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks