#1
|
|||
|
|||
minimum charge
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. |
#2
|
|||
|
|||
Hi,
Give this a try =IF( ISBLANK(A5),"", IF(A5<1,"$57.00",IF(A5>=1,"$58.70",0))) |
#3
|
|||
|
|||
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 |