Excel 7 If then else

January 25, 2011 at 08:30:34
Specs: Windows XP
I have a large table 48K with columns for acct and cost sheet. The cost sheet column is a code which corresponds to another small table containing the values for the cost sheets.
Table 1 C1 acct # xxx22110090 C2cost sheet # CZCa1 C3 $$Amt 250
xxx32117777 cost sheet # ABCa2 C3 $$Amt 34,500
Table 2
CZCa1 = 10%
ABCa2 =38.4%
I want an if then syntax for if C2 contains CZca1 then C3 $$AMT = 250/1.10

Can you help me?

See More: Excel 7 If then else

Report •

January 25, 2011 at 10:10:01
Please refer to the How To referenced in my signature line before you post any more data in this forum. The How To will explain how to format the data so that it lines up properly.

Is this what you are looking for?

=IF(C2 = "CZca1", 250/1.10, "")

or, simpler:

=IF(C2 = "CZca1", 227.28, "")

250/1.10 = 227.2727273

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question