Microsoft Office Forums - View Single Post - minimum charge

Thread: minimum charge

View Single Post

Old

03-14-2017, 09:19 AM

kalees

kalees is offline

kalees uses Windows 7 64bit

Windows 7 64bit kalees uses Office 2016

kalees uses Office 2016

Office 2016

Novice

Join Date: Feb 2017

Location: UK

Posts: 3

kalees is on a distinguished road

Default

Hi,

Give this a try

=IF( ISBLANK(A5),"", IF(A5<1,"$57.00",IF(A5>=1,"$58.70",0)))

Reply With Quote