Home » Forums » Open Source Learning Center » Question and Answer

Excel 2003 - "IF" function

Submitted by Kalop on 4 December, 2012 - 05:20

This function - IF(C10=$BX$5,$BO$4,"")....... is written in cells BX10:BX500.......
and work correctly in single row, but every time the new row start, for sample: .....IF(C11=$BX$5,$BO$4,"")
data in previous cell BX in that case BX10 disappear.

It is possible to create formula that prevent that??

Please he

‹ VBA dynamic model steam production by using sun radiation in Africa Function Calling a DLL takes too long to process ›
»

If I understand your aims

Submitted by AndyLitch on 4 December, 2012 - 07:19.

If I understand your aims correctly, the function relative/absolute references look good.

The function in English
If the value in the formula cell equals the value in $BX$5 then display the value in $BO$4 otherwise display nothing.

can you attach the file ?

»

attach the file

Submitted by Kalop on 4 December, 2012 - 11:12.

how I can do it?

»

When you open a new thread it

Submitted by AndyLitch on 4 December, 2012 - 11:14.

When you open a new thread it gives the option to upload (attach) a file ...

»
Nick's picture

log in, and you can edit your

Submitted by Nick on 4 December, 2012 - 11:50.

log in, and you can edit your original thread and add a file..

»

File send

Submitted by Kalop on 4 December, 2012 - 11:59.

File send in new post "Excel 2003 - "IF" function and attach file"

»