Your formula doesn't really work fine, as you are saying that if G3=1%
return both 'yes' and 'no'. You also nested IF statements that really
aren't necessary. Try this instead:

=IF('Funding'!$G3<=1%,"yes","no!") which will return "no!" for any
value greater than 1%

As for the rest of your question, I don't understand what it is you are
looking for. If you could be more specific with details, please,
someone may be able to give some ideas for solutions.

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382618