MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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