View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SuperBee SuperBee is offline
external usenet poster
 
Posts: 5
Default IF OR NESTED STATEMENT

My result was "false". Should there be an "or" in the statement?
--
Many thanks!


"SuperBee" wrote:

Can someone help with If statement.

Column A - text entered will be Audit or Review
Column B - numbers 0 and higher

Column C - If A = "audit" and B is = or 200 then C results as A-200 OR If
B = "review" and B is = or 60 then C results as C-60

Many thanks!