Microsoft Office Forums - View Single Post - [Solved] Conditional formatting

Thread: [Solved] Conditional formatting

View Single Post

Old

07-11-2016, 01:29 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 10

Windows 10 Kevin@Radstock uses Office 2016

Kevin@Radstock uses Office 2016

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Hi

How about in G3:

=IFERROR(SUM((A3+$K$2)/(B3-2)),"")
or
=IF(ISERROR(SUM((A3+$K$2)/(B3-2))),"",SUM((A3+$K$2)/(B3-2)))

Reply With Quote