Okay, so what I have is a value in one cell that can change based on the selection of a record in a database (cell A in the examples below). In cell B, I'm using a formula that calculates a value based on the value of cell A and a fixed number like this "=sum(A1/.6)" So, cell B changes in value depending on the value of cell A (which is being determined by a record referenced in a database). Cell C is a fixed value that only changes when a different record from the database is selected, just like the value of cell A. I need cell D to compare cells C and B. If the value of cell B is greater than cell C, I need cell D to display the value of cell C but if cell B is less than cell C, I need cell D to display the value of cell B.
Example 1: (cell B is greater than cell C so cell D needs to display the value of C)
----A---------B---------C---------D
$25.00-----42--------21-------21
Example 2: (cell B is less than cell C so cell D needs to display the value of B)
----A---------B---------C---------D
$7.00-----10--------21-------10
Hope I've explained this correctly. Any help would be greatly appreciated.
Thanks,
El T
Bookmarks