I want to add a range of cells (B3:K3) if cell L3 is >=.8. If L3 is <.8, then I want the result to return as blank. Thanks to anyone who can help.
You can try constructing your formula as below
Also attached the sample file for your ready reference
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more
Not practical, just in case