Home > IT Answers > Lotus Domino > Lotus Notes formula
Lesgibbo
5 pts.
 Lotus Notes formula
Lotus Notes, Lotus Notes Formulas
@IF(T11>0,@ROUND(F11*1/21,2),@ROUND(F11*1/6,2)) This is a formula I have created to calculate VAT depending on which cell is entered i.e. if an entry is made in T11 VAT is entered at 5% otherwise it is entered at 20%. I wish to add to this formula so that if an entry is made in cells J11 to Y11 which equals the amount in cell F11, it should return a value of 0(zero). Can anyone help?

Software/Hardware used:
ASKED: September 30, 2012  5:34 PM
UPDATED: October 1, 2012  11:59 AM
RELATED QUESTIONS
Answer Wiki:
I think you have Lotus Notes (a groupware/email platform) confused with Lotus 1-2-3 (a spreadsheet package).
Last Wiki Answer Submitted:  October 1, 2012  2:53 pm  by  Stiletto   2,700 pts.
All Answer Wiki Contributors:  Stiletto   2,700 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _