I want to put an 'if' command into excel, but how do I make the 'value if true' and the 'value if false' Yes and No, as all it will let me do is numbers as the outcome!
2007-02-08 04:15:44 · 7 answers · asked by George Harris 3 in Computers & Internet ➔ Software
you may get help about if in excel
=IF(condition;true;false)
EXAMPLE:
=IF(A1>80;"GOOD";"BAD");
2007-02-08 04:21:01 · answer #1 · answered by iyiogrenci 6 · 1⤊ 0⤋
Put double quotes " before & after the Yes & before & after the No.
2007-02-08 04:21:21 · answer #2 · answered by Well, said Alberto 6 · 2⤊ 0⤋
it really is a function, observed as decrease. From the Insert menu (between View and format), opt for function. opt for the function observed as decrease. even if that's not uncomplicated to make sure out a thanks to apply purposes in Excel, seem it up of their help record.
2016-11-26 02:49:33 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Try using the values in quotations. example
=IF(A1=3,"yes","no")
2007-02-08 04:22:44 · answer #4 · answered by Pawn 2 · 1⤊ 0⤋
Hi
Use " (this is keyed in by pressing shift2) before and after yes and no. Like this:
=IF(A4=1200,"yes","no")
Good luck.
2007-02-08 04:25:37 · answer #5 · answered by benny boy 2 · 1⤊ 0⤋
utyeevjdsvdsvklnvcklxvcf252c52c52c51v1c2xc2vv d2x252v 0 0
xc
x
x
+s+s+s+d4f5f+f+d--8d98d8d45cc4f7f*/*s/s/s/s*---+FDGGFF FFFFFFFFF GGD
2007-02-08 04:22:21 · answer #6 · answered by Anonymous · 0⤊ 2⤋
=IF(C5<=C6,D1,D2)
Where d1, d2 contain yes and no and c5 and c6 contain comparison values
2007-02-08 04:29:59 · answer #7 · answered by TKE 1 · 0⤊ 1⤋