View Single Post
 
Old 07-27-2015, 05:48 AM
msnarayanan msnarayanan is offline Windows 8 Office 2013
Advanced Beginner
 
Join Date: Jul 2015
Posts: 37
msnarayanan is on a distinguished road
Default formula for arriving at a result on condition

dear sirs

i have a sheet with the following headers:
B C D
1 Name Amount tax
2 XYZ 100

i would like to have a formula to get the tax amount (say 3%)
on the amount shown in c2. the tax element varies from
person to person. will the following formula work:

=iif((b2="XYZ"),round(c2*3%,2)),"

please correct me if i am wrong.

thanks

m s narayanan"
Reply With Quote