I'm a newbie to the forum. I learned Excel by the OJT and "Stumble" methods. I am starting to wish I had used the forum sooner. I don't know the most efficient(easiest with least amount of formulas/columns) way to do the following:
H has imputted data
J has imputted data
K needs to show either H or J data depending on which is less but only if H is greater than 0
Example (I am trying make sure I can understand what I'm doing not implying you don't understand.)
H8 has value $5000.00
J8 has value $1000.00
K8 would be J8 "$1000.00"
H9 has value $0.00
J9 has value $300.00
K9 would be $0.00
H10 has value $500.00
J10 has value $750.00
K10 would be $500.00
Bookmarks