formula help
Posted by Bob on October 19, 2001 3:50 PM
I need a formula for the following problem.
if b5 = jrc and c5 = ref then d5 will automatically have 35.00 appear.
Posted by Paul on October 19, 2001 5:09 PM
Put =IF(AND(B5="jrc",C5="ref"),35,"") in D5 and format as number with 2 decimals
