Excel 2007 Text Function

Sounds a dumb question, but i cant find this simple answer
What I want to do is test the condition in 2 cells, and if they are true place the word ERROR into another cell

So if A1 = True
and A2 -True
Them place error into A3
BUT i dont want to put the formula into A3
what I am trying to use is this.....
=IF(AND(A1="NO",A2="NO,A3="ERROR"
But I cant find the correct formula, I CANT PUT FORMULA IN A3

Anyone got any good ideas?

ta

G

Try this :

=IF(AND(A1="NO",A2="NO"),"ERROR","")

Regards...

Originally Posted by madbrit

=IF(AND(A1="NO",A2="NO,A3="ERROR"
But I cant find the correct formula, I CANT PUT FORMULA IN A3

One of the fundamental rules of formula is that they can not directly change the value in another cell, so either your formula goes in A3 or you'll have to use some (fairly simple) VBA to set the value in A3.

Which do you prefer?

What would be the VBA to do this, macro?

Ta


G

Something like this, perhaps ...

Please Login or Register  to view this content.