View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrey Andrey is offline
external usenet poster
 
Posts: 1
Default What if scenario

Hi, I'm trying to find a way to allow a change to an operator within an If
statement. This is what I have at present:
=IF(AND(C2=G$3,D2<J$3),(D2+(D2*L$3)),L$4)
This allows me to change the values in the referenced cells, but what I'd
like to do is be allowed to include a reference to the cell containing the
operator < within D2<J$3, to either , =, =, etc. Is this possible?

Can anyone help please.
Thanks.