View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
deen deen is offline
external usenet poster
 
Posts: 45
Default If Condition Problem

Hi,

=IF(AND(B460<21),"NOT",IF(B421<60,"ELI"))

this formula not working,

i want result in A2 Not or ELI,

If thr is any possible do in macro pls let me abt the, bcoz new to the
macro.