Hi guys
Can someone point out to me the error of my ways with the following formula.
It has been driving me nuts but I am fairly new to this so I am obviously missing something probably very simple.
Where the value I want to display in the chosen cell E39 is based on the value of either D39 or K39?
=IF(D39>0,85,0),IF(K39=85,32,0))
Not sure how to compensate if both D39 and K39 requirements are met at the same time??
Thanks for any help that may be forthcoming.
Kind regards
Wayne
Bookmarks