C
cnistler
I'm looking to take the lesser of 2 data values (in different colums) but
only when the data is greater than 100. Here's an example:
Col A Col B Desired result
664 0 664
803 742 742
665 33 665
0 745 745
42 84 42
I'm familar with using an Iff statement to return the lesser of the two
values but I am running into problems because I need it to return the lesser
of two values ONLY WHEN either column A or B is greater than 100. If neither
column A or B is greater than 100, column 1 is the desired result.
Note: I'm not to familar with SQL so if there is a way to do this in Iff
form, I'd perfer the Iff--otherwise I'll learn.
Thanks for the help!
only when the data is greater than 100. Here's an example:
Col A Col B Desired result
664 0 664
803 742 742
665 33 665
0 745 745
42 84 42
I'm familar with using an Iff statement to return the lesser of the two
values but I am running into problems because I need it to return the lesser
of two values ONLY WHEN either column A or B is greater than 100. If neither
column A or B is greater than 100, column 1 is the desired result.
Note: I'm not to familar with SQL so if there is a way to do this in Iff
form, I'd perfer the Iff--otherwise I'll learn.
Thanks for the help!