Convert if formula to array formula

[Vishaal]

Hi,

We have the following formula

=if(c1,c1,if(b1:b<>"",$A$1,""))

now we want to convert it to an array formula so that it will work on complete c column

Help pls

 

[gaz_chops]

Does that formula work for you?

 

[Vishaal]

Oh sorry, there is one mistake

=if(c3,c3,if(b3:b<>"",$A$1,""))

 

[gaz_chops]

And that currently works for you?

 

[Vishaal]

Yes, but when we want it use as Array formula, i am unable to understand, how to use

=if(c3,c3,if(b3:b<>"",$A$1,""))
=if(c4,c4,if(b4:b<>"",$A$1,""))
=if(c5,c5,if(b5:b<>"",$A$1,""))

I have done it by copy pasting and editing, now want to use as Array so dont need to copy, paste and editing

 

[gaz_chops]

I can't see how this part IF(B3:b<>"" is currently working!

 

[Vishaal]

pls check below details

We have used the formula in column c

	A	B	C
1	06-09-2020 14:04	0.3625	01-08-1900 07:12
2	Indent Reference Number	Test	Time
3	CFD-1	Me	09-06-2020 13:44
4	CFD-2	You	09-06-2020 13:44
5	CFD-3	Other	09-06-2020 13:44
6	CFD-4	Me	09-06-2020 13:44
7	CFD-4	You	09-06-2020 13:44

 

[Darren Bartrup]

Your formula shouldn't be working based on the error that gaz_chops mentioned.
In addition to that - your first argument just says C3 which, for a numeric, will always return TRUE unless the value in column C3 is 0. The first argument in an IF statement should return TRUE or FALSE.
But you say the formula is in column C and it references column C - is this causing a circular reference?

 

[Vishaal]

Dear Darren,

I dont know how its working,

But we have got the results from this formula putting manually

Now we want to convert it in array formula

 

[Vishaal]

Ok,

Can we do this through array formula

Condition are
If we enter a name or value in B3 then get the timestamp on c3