LinkBack URL
About LinkBacks
This is an estimate bid tabulation worksheet. NEI is my company. If I want to write a formula in cell G21 that calculates if cells J21:S21 all are NO BID then list cell I21 but if J21:S21 has a min number then carry the min number.Estimate Tab.xlsx
This is an estimate bid tabulation worksheet. NEI is my company. If I want to write a formula in cell G21 that calculates if cells J21:S21 all are NO BID then list cell I21 but if J21:S21 has a min number then carry the min number.Estimate Tab.xlsx
Try:Formula:
=IF(COUNTIF(J21:S21, "NO BID")=5, I21, MIN(J21:S21))
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks