View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default Formula Won't Work

On Feb 13, 6:12*am, George wrote:
Hello, can someone please help me with the following formula;
=IF(F5<=2999.99,"25%",IF(F5=3000,"50%",IF(F5=500 0,"75%",IF(F5=7000,"100%"))))
For some reason it calculates the 25% and 50% correctly, but it won't
calculate the 75% or 100% at all, it just stays at 50%


See the other same question