Is blank
Closed
hamam
-
23 Oct 2011 à 03:07
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Oct 2011 à 04:54
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 23 Oct 2011 à 04:54
Related:
- Different dates of "end to end encryption message" on blank chat?
- Do message requests on instagram expire - Guide
- How to message yourself on WhatsApp: Android, iPhone - Guide
- Blank discord name ✓ - Internet & Social Networks Forum
- You can't message this account unless they follow you - Instagram Forum
- Msn chat history - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
23 Oct 2011 à 04:54
23 Oct 2011 à 04:54
you cannot put a formula in a cell referencing this cell itself (leads to circular reference). you can put the formula in another empty cell.
suppose cell reference is in column A form A2 down
then in B2 type a formula
=ilf(A1="",3,5)
you can copy B1 down
this formula meaning is
if A1 is blank than B1 will be 3
if it is not blank B1 will be 5
of course you can write and run a macro to avoid circular reference
suppose cell reference is in column A form A2 down
then in B2 type a formula
=ilf(A1="",3,5)
you can copy B1 down
this formula meaning is
if A1 is blank than B1 will be 3
if it is not blank B1 will be 5
of course you can write and run a macro to avoid circular reference
Sub test()
Dim r As Range, c As Range
Set r = Range(Range("A2"), Cells(Rows.Count, "A").End(xlUp))
For Each c In r
If c = "" Then
c = 3
Else
c = 5
End If
Next c
End Sub
