MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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