Link to home
Start Free TrialLog in
Avatar of Ian Bell
Ian BellFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Dave
Dave
Flag of Australia image

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

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","")


Avatar of Ian Bell

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


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

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
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??
ASKER CERTIFIED SOLUTION
Avatar of Ian Bell
Ian Bell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hey Teylyn

I see you are on Janitor duty

Sorry must have forgotten to close it

Please do so

Thanks

Ian