Page 127 - الحاسب الآلي ثانية إرشاد 2
P. 127

Excel ‫اﻟﺪوال ﻓﻰ ﺑﺮﻧﺎﻣﺞ‬                                  ‫اﻟﻔﺼﻞ اﻟﺴﺎﺑﻊ‬

=IF (Logical_condition, Value_if_true, Value_if_false)
=IF(C11,"Good","V Good")

                               TRUE  C11

                        FALSE  C11                      "Good"

                                            . “V Good"

IF
                                                  Nested IF

              .                               %٨٥
                   D2                   %٨٥ %٧٥
                                       %٧٥ %٦٥
: E2                                %٦٥ %٥٠

                                               E2

=IF(D2>=85%," ",IF(D2>=75%," ",
IF(D2>=65%,"‫"ﺟﻴﺪ‬,IF(D2>=50%,"‫"ﺿﻌﻴﻒ‬،" "))))

                                                             ١٢٧
   122   123   124   125   126   127   128   129