View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dust Devil Dust Devil is offline
external usenet poster
 
Posts: 1
Default Dealing with +/- Values, Need Help

Hi, I'm trying to create a formula that will either tell the reviewer that
"YES" a variance report needs to be written, or "NO" it doesn't. I've tried
IF with AND/OR, thought about Vlookup and even dabbled with select case. My
situation is this, a variance report needs to be written if the variance is
equal to or greater than plus or minus $100,000, AND equal to or greater than
plus or minus 10%. I would be fine it the plus or minus wasn't thrown in
there, not sure how to make this work. Can anyone help me?

Thank you in advance!
--
DD