Ian Bell
asked on
Excel formula required
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
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
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","")
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","")
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","")
and, if u need to have "LAY" in B10 then use
=IF(D10>=C10,"LAY","")
ASKER
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
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.
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","")
ASKER
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
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
u missed http:#a33135507 ??
<<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??
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??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey Teylyn
I see you are on Janitor duty
Sorry must have forgotten to close it
Please do so
Thanks
Ian
I see you are on Janitor duty
Sorry must have forgotten to close it
Please do so
Thanks
Ian
What are you trying to do?
Cheers
Dave