IF Function

[jotto]

I'm trying to imput data in several cells that are progressive in the Update

ie: #1 #2 #3 #4 UPDATE

I want to imput data in #1 and it appears in UPDATE,
I imput data in #2 and that susequently appears in the UPDATE
and conversley in#3 and #4

I've tried the IF function, but I'm not getting the syntax right

 

[kunal_shrivastava]

Hi jotto,

Can you please share sample data and the IF function you are trying to use..

Regards,
Kunal

 

[lenze]

Hi and welcome to the board!!!
If I understant you, you can use

=LOOKUP(9.99999999999999E+307,A2:D2)

for numbers

lenze

 

[jotto]

Thanks,
I'm not sure how it works but it has done the trick.
I've just begun to explore formulae and need to get my head round code.
Thanks for the number