conditional formatting

i have an simple invoice sheet and in "total" coloumn i need to put a
formula like IF < 8.50 THEN VALUE =8.50
it is something like we dont do delivery less then 8.50 so if the TOTAL is less
than 8.50 then it should turn in to 8.50 automatically.

can someone help pleaseee\t
Posted On: Saturday 10th of November 2012 05:12:07 AM Total Views:  118
View Complete with Replies