ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What if scenario (https://www.excelbanter.com/excel-discussion-misc-queries/124661-what-if-scenario.html)

Andrey

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.



All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com