Looking for the If formula for the following: columns A,B,C and D will have one of four letters in them or be blank. If one of the letters is y then column E same row will = 5.0. If one of those letters is x then column E same row = 7.0 There will never be a y and x in the same row. As always you guys are great.
There is many ways of achieving that
=IF(COUNTIF($A1:$D1,"X")>0,0.7,IF(COUNTIF($A1:$D1,"Y")>0,0.5,""))
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Many Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks