View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
QuickLearner QuickLearner is offline
external usenet poster
 
Posts: 14
Default Is Cell D3 within 10% of B3 True or false?

Usind AND function

=IF((AND((((B3-D3)/B3)*100)<=10,((((B3-D3)/B3)*100)=-10))),TRUE,FALSE)

Rachad


"Mark B" wrote in message
...
I have two Columns of Data,
I want to know if the Data in column D is within 10% + or - of the data in
column B
e.g Is Cell D3 within 10% of B3 True or false?
Should be simple but I can't figure it out.