Need help with an invoice using excel
Posted by Eric on November 09, 2000 9:33 PM
I know how to do the invoice but I'm having trouble with the discount column (f). Using
=IF(AND(CONDITION1,CONDITION2)="YES"),0.1*CELL#,0)
I keep getting a 0 value in the f column, according to my professor I should be getting a number other than
zero? Why is this happening?
Please respond asap.
Eric
eric946@earthlink.net
Posted by Celia on November 09, 2000 11:17 PM
Eric
Try this :-
=IF(AND(CONDITION1,CONDITION2)=TRUE),0.1*CELL#,0)
Celia
