We help IT Professionals succeed at work.

Excel formula required

Ian Bell
Ian Bell used Ask the Experts™
on
Hello

I would like to seek an answer to a tedious problem I have with a formula. I have tried all kinds of solutions using helper columns but to no avail. I always get the Circular Reference messages.
Just need a solution that I can add to my existing formula in the "LAY" column.
Many Thanks
Ian
Lay-Formula.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can't both put a formual in B10 and have it simultaneoulsy blank ( Cells A10..B15 should be blank)

What are you trying to do?

Cheers

Dave
Place the following value in cell B10

=IF(C10=D10,"LAY","")

This should give you a value of LAY , else leave the cell blank. Do this formula appropriately for cells B1 thru to B15.
=IF(C10=D10,"LAY","")

Open in new window

Commented:
your attached file does not have enough formulas to show circular reference error!

and, if u need to have "LAY" in B10 then use
=IF(D10>=C10,"LAY","")


Ian Bellretired

Author

Commented:
brettdj

oops sorry I meant to have put cell A11..B15 to be blank

I am trying to copy formulas down but when "LAY" appear without "BACK" along side it then that completes the series and no further BACK or LAY appears. I have the BACK under control only the LAY needs a formula
Thanks
Ian


My bad left out part of formula as you require.
Place the following value in cell B10

=IF(C10=D10,"LAY","")

This should give you a value of LAY , else leave the cell blank. Do this formula appropriately for cells B1 thru to B15.
=IF(C10>=D10,"LAY","")

Open in new window

Ian Bellretired

Author

Commented:
richardsk-octjamaica:

C10 just happened to equal D10 coincidence only
I want the first figure that is equal to or greater then that completes the series
you will notice C10 thru C15 all comply with the rule.
C11..C15 should be blank
slightly more difficult
Any further thoughts?
Ian

Commented:
u missed http:#a33135507 ??

Commented:
<<I am trying to copy formulas down but when "LAY" appear without "BACK" along side it then that completes the series and no further BACK or LAY appears. I have the BACK under control only the LAY needs a formula>>


Can u explain further??
Is appearance of "LAY" dependent of the appearance of "BACK"??
How is the appearance of "BACK" controlled by? is that linked with the values in Column C and D??
retired
Commented:
Hi All

I have managed to splve the puzzle using a helper column
It was a complicated exercise trying to explain whole worksheet hence I just sent you a mini sized part of  the problem
Thanks for all your efforts
Ian
Ian Bellretired

Author

Commented:
Hey Teylyn

I see you are on Janitor duty

Sorry must have forgotten to close it

Please do so

Thanks

Ian