# Thread: Solved: How to test formulas results?

1. ## Solved: How to test formulas results?

Hello. My question is probably very basic: I am learning bymyself VBA and I am having trouble to work with the results of a formula.

If WorksheetFunction.IsNA(Cells(Go, 20)) Then...

How to test the same way if a cell is blank or for example =6?

In this examples,
cells(Go,20) is either blank or contains a formula returning a text.
cells(Go,21) is either blank or contains a formula returning a value

To make it work, I had to first copy/paste as value the result of the formula calculation, but I am sure I could skip this step.

Thanks!

[VBA]While Go < Lignes
Go = Go + 1
If Cells(Go, 20) <> "" Then If Cells(Go, 21) > 0 Then ....
Else
....
End If
ElseIf Cells(Go, 21) = Cells(Go,3) Then ....
Else
End If
Wend[/VBA]  Reply With Quote

2. To test whether a cell is empty or not

[VBA]
if cells(1,1)="" Then.....
If Cells(1,1).Value="" Then ...
if Isempty(cells(1,1)) Then ...
If cells(1,1) <>"" Then ...
If Cells(1,1).Value <>"" Then ...
If not Isempty(cells(1,1)) Then ...
[/VBA]

To test the value of a cell:

[VBA]
If Cells(1,1)=5 Then ...
if Cells(1,1).Value= 5 Then ....
If Cells(1,1)="text" Then ...
[/VBA]  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•