Microsoft Office Forums - View Single Post - [Solved] Error in If statements

Thread: [Solved] Error in If statements

View Single Post

Old

05-28-2016, 10:22 PM

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

As you have Excel 2016, use the IFS function.

=IFS(J18=76,P18*13,J18=89,P18*20)

Reply With Quote