View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
abs abs is offline
external usenet poster
 
Posts: 10
Default Can I add a percentage formula to an IF statement?

I would like to me able to add percentages to an IF formaule allow for a
margin of error, say 10%. If anyone knows a way round it be much obliged.
the cell reads "=if(H2<=10%, "TRUE", if(h2=h3, "true", if(h210%, "false")))

Thanks
Abs