LinkBack URL
About LinkBacks
Hi,
What do I change in the following formula to get it to work?
If C1=abc and G1= def, then add D1HTML Code:
If C1=abc and G1= ghi, the subtract D1
If not then leave blank
Mike
Hi,
What do I change in the following formula to get it to work?
If C1=abc and G1= def, then add D1HTML Code:
If C1=abc and G1= ghi, the subtract D1
If not then leave blank
Mike
=IF(AND(C1="abc",G1="def"),+D1,IF(AND(C1="abc",G1="ghi"),-D1,""))
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Hi Sean Thomas,ragavan.sridar1
I keep forgetting about the "and"
Thanks for the help
Mike
Check this.
HTML Code:
Thanks!
Raga.
Please,mark your thread [SOLVED] if you received your answer.
Click the little star * below, to give some Rep if you think an answer deserves it.
I learnt so many things from these links.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks