LinkBack URL
About LinkBacks
The syntax is
=IF(AND(D17="Dependent",H9="1AY"),3500,"")
Use the built in help to understand formula.
Put the cursor in the formula bar within the formula you wish to use then click the fx button to the left.
Then click Help on this function
The syntax is
=IF(AND(D17="Dependent",H9="1AY"),3500,"")
Use the built in help to understand formula.
Put the cursor in the formula bar within the formula you wish to use then click the fx button to the left.
Then click Help on this function
Last edited by Marcol; 09-22-2011 at 01:33 PM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hi,
Thanks, I have a similar requirement with more combinations.
Like, if two cell values are 'x' and 'y' the target cell value should become "john", in case of other combinations, the same target cell value should become as "peter".
I would like to know how do we embed these as codes in the worksheet? or in a module? because I don't need these to be in formula tab as is it is not protected.I require this as an automatic update without using any button or userform.
Hope my requirement is clear. Can anyone help me on this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks