can if and then be used in formulas

[cfinch100]

hi I have tried this formula

Please Login or Register  to view this content.

,what im after is, if j6=8 then n6=i6,can not seem to be able to use then and it keeps wanting to put times symbol inbetween,anyone no if this can be done please
cheers colin

[Ace_XL]

Do you intend this in an Excel formula rather than in Vb code?

If so, you need..in Cell N6

=IF(J6=8,N6,"")

[AkaTrouble]

double post

[AkaTrouble]

IF would be same as it has TRUE FALSE argument

IF(J6=8, do something , else if false do something else)

if you want to check both J6 and N6 you would need a nested IF ( an IF inside your first IF) but you would need what if false and J6 not = 8 or N6 not = 16

you woud be but we need to know what if false do we do nothing does it = something

[cfinch100]

hi
thanks both of you,will have another go using

Please Login or Register  to view this content.

and see if I can sort other problems myself ,and get back to you if I am having more trouble
cheers colin

[cfinch100]

hi
thanks both of you,will have another go using

Please Login or Register  to view this content.

and see if I can sort other problems myself ,and get back to you if I am having more trouble
cheers colin