The if formual in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Target : Check if value (A/100) = value C. If
not "Wrong !!"

A B C
OK / Vrong !!
53,3000 OK 0,5330
51,3000 OK 0,5130
49,3000 Wrong !! 0,4930
47,3000 Wrong !! 0,4730
27,3000 OK 0,2730
0,0000 #N/A #N/A
40,0000 OK 0,4000
50,0000 OK 0,5000
0,0000 OK 0,0000
58,3000 OK 0,5830
56,3000 Wrong !! 0,5630
54,3000 Wrong !! 0,5430
52,3000 OK 0,5230
32,3000 Wrong !! 0,3230
0,0000 #N/A #N/A
40,0000 OK 0,4000
50,0000 OK 0,5000
0,0000 OK 0,0000
 
Back
Top