G
Guest
I want to create a conditinal function that references 2 cells to be true -
this is what I have used for the formula but it is not referencing the C29
value to be true before doing the rest.
for example:
=IF(AND(C29="X",G29<L29),1,G29/L29)
Thanks for your help
this is what I have used for the formula but it is not referencing the C29
value to be true before doing the rest.
for example:
=IF(AND(C29="X",G29<L29),1,G29/L29)
Thanks for your help