Thread: Can I add a percentage formula to an IF statement?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Can I add a percentage formula to an IF statement?
=IF(OR(H2<0.1,H2=H3),TRUE)

"Abs" wrote:

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
Reply With QuoteReply With Quote