Help with IF formula
Posted by Dianne on November 21, 2000 9:26 AM
I am having a problem with a formula. Here is what I need to do:
I have a basic =sum(D6*1.40) Now, if column B is showing a "B", I need it to round up to nearest nickel. If it is showing "ST" i do not want it to round up. I have tried many ways, but can only B to work, but not when an ST is in the column. Maybe I am looking at the wrong formula all together. Thanks in advance for your help.