Re: ]] XL-mania [[ If Function

 

Hi,
I think you should write this formula to Cell D3216 : =IF(OR(B3216=1,C3216=1),A3216,"")

Which means : IF Cell B3216 OR Cell C3216 IS Equal to 1, Then Write the value of cell A3216 IN Cell D3216, but if neither A or B is equal to 1 then write Nothing ("") on Cell D 3216

Hope it helps...

[Sent from AXIS SilverBerry®]

---

From: "andersonappraisals@sbcglobal.net" <andersonappraisals@sbcglobal.net>

Date: Mon, 04 Jan 2010 16:38:38 -0000

To: <XL-mania@yahoogroups.com>

Subject: ]] XL-mania [[ If Function

 

Having trouble with =If function. My goal is to copy the value in cell A if cell B OR cell C has a specific expression. In other words, if cell B or cell C equals 1 then copy contents of cell A into cell D. Can anyone help me with the proper syntax? Example; =IF(F3216=1,D3216) will return the contents of cell D3216 if cell F3216=1 into the cell where the syntax is located. I want to include a second (if cell =1) into the string.

__._,_.___

Reply to sender | Reply to group

Messages in this topic (2)

Recent Activity:

• New Members 76

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Resolusi 2010 XL-mania: terbitkan buku lagi... hehehe...          |  
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Going Green: Your Yahoo! Groups resource for green living

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___