minimum charge

Trapshooter1956 · #1 03-14-2017, 08:57 AM

Trying to set up a formula like this.
if a5 is blank then blank, if a5 is less than 1 then = $57.00, if it = 1 or greater then = $58.70.

I know this is probably simple but I'm not have any success.

Thanks.

kalees · #2 03-14-2017, 09:19 AM

Hi,

Give this a try

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

Trapshooter1956 · #3 03-14-2017, 09:36 AM

Excellent!!!

Thank You very much.
Jerry.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chart y-axis minimum, auto not working?	gebobs	Excel	0	03-24-2016 11:05 AM
Need formula to determine minimum quantity needed per price	mbking	Excel	2	02-10-2015 01:46 PM
What are the minimum margins most printers can handle?	20GT	Word	3	11-08-2014 10:40 PM
STDEV minimum number of points	littlepeaks	Excel	0	01-15-2012 06:40 PM
Word Minimum Margin	rangeshram	Word	0	09-24-2008 01:38 AM