View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Macro For If Function

in F1

=IF(D1=E1,"Matched","Unmatched")


"Akash" wrote:

hi,

I have 6 Columns

A = Number
B = Number
C= Number
D= A x B x C
E= Input Number by user
F = If(D = E) = Matched/Unmatched)

I want a macro the value of Column D = E then it should display
Matched or Unmatched in Column F.

Is it possible.

Thanks in Advance