Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change operater in Excel formula
Hello,
depending on a certain circumstances, a formula must change from "X = Y" to "X < Y". Can this be done (e.g. using "if", or otherwise) ? Thank you in advance. Merry Christmas, H.G. Lamy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change operater in Excel formula
You didn't give us a lot to work with, but I think you are looking for
something like this... =IF(<<your condition,<<formula with x=y,<<formula with x<y) -- Rick (MVP - Excel) "H.G. Lamy" wrote in message ... Hello, depending on a certain circumstances, a formula must change from "X = Y" to "X < Y". Can this be done (e.g. using "if", or otherwise) ? Thank you in advance. Merry Christmas, H.G. Lamy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change operater in Excel formula
As an alternative, if "the formula" is very long, you may try this:
<< your formula with X=Y replaced with (((X<Y)+your condition)=1) Hope this helps / Lars-Åke On Sat, 26 Dec 2009 14:17:51 -0500, "Rick Rothstein" wrote: You didn't give us a lot to work with, but I think you are looking for something like this... =IF(<<your condition,<<formula with x=y,<<formula with x<y) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change operator in Excel formula
Since my formula is already quite long and complicated, I'd like to avoid
repeating most of it (once for the "if"-part, and again for the "then"-part). Instead, I was trying to REPLACE ONLY THE OPERATOR INSIDE THE FORMULA ("=", or "<", respectively), depending on the condition met. However, I did not find a workable solution for that. Can anybody assist ? Thank you in advance! Kind regards, H.G. Lamy "H.G. Lamy" wrote in message ... Hello, depending on a certain circumstances, a formula must change from "X = Y" to "X < Y". Can this be done (e.g. using "if", or otherwise) ? Thank you in advance. Merry Christmas, H.G. Lamy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change the formula language of Excel? (FR = UK) | Setting up and Configuration of Excel | |||
Is there a formula which could change -£1.50 to £1.50 in Excel? | Excel Discussion (Misc queries) | |||
Formula in excel to change - to + | Excel Discussion (Misc queries) | |||
Why Excel does automatically change the formula? | Excel Worksheet Functions | |||
Excel formula to change a value every 2 weeks | Excel Discussion (Misc queries) |