Hi,

Am Tue, 18 Jun 2013 20:39:00 +0100 schrieb NubianNewbie:

I need to do a formula that would show if E6 plus H6 is greater than or
equal to 60 then show 60 but if its less than 60 to show 5% of that
number. I see to be putting in the equation that would show it to be
false if less than but it doesn't show 5% of that number.

try:
=IF(E6+H6=60,E6+H6,0.05*(E6+H6))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2