Help with populating multiple IF functions
Closed
MelyElly
Posts
3
Registration date
Wednesday November 21, 2012
Status
Member
Last seen
November 23, 2012
-
Nov 21, 2012 at 07:49 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 28, 2012 at 11:55 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 28, 2012 at 11:55 AM
Related:
- Help with populating multiple IF functions
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- Photoshop multiple selections - Guide
- Accessor and mutator functions c++ - Guide
- Mpc-hc multiple instances - Guide
2 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 28, 2012 at 11:55 AM
Nov 28, 2012 at 11:55 AM
Hi MelyElly,
I am sorry for the delayed response. I used Microsoft Excel's fill handle to drag and the formula copied as below, don't need to enter it manually:
=IF(ISNUMBER(SEARCH("13.99",Income!C1)),"1","")
=IF(ISNUMBER(SEARCH("13.99",Income!C2)),"1","")
=IF(ISNUMBER(SEARCH("13.99",Income!C3)),"1","")
=IF(ISNUMBER(SEARCH("13.99",Income!C4)),"1","")
To use Microsoft Excel's fill handle copy a cell or range of cells by holding down CTRL while you position the mouse pointer on a cell or cell range border so that it changes to a copy pointer, and then dragging the cell or range of cells to another location.
Please revert for clarification.
I am sorry for the delayed response. I used Microsoft Excel's fill handle to drag and the formula copied as below, don't need to enter it manually:
=IF(ISNUMBER(SEARCH("13.99",Income!C1)),"1","")
=IF(ISNUMBER(SEARCH("13.99",Income!C2)),"1","")
=IF(ISNUMBER(SEARCH("13.99",Income!C3)),"1","")
=IF(ISNUMBER(SEARCH("13.99",Income!C4)),"1","")
To use Microsoft Excel's fill handle copy a cell or range of cells by holding down CTRL while you position the mouse pointer on a cell or cell range border so that it changes to a copy pointer, and then dragging the cell or range of cells to another location.
Please revert for clarification.
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 23, 2012 at 12:04 PM
Nov 23, 2012 at 12:04 PM
Hi MelyElly,
Your formula is close to what you want to do. To match the subsequent D cell with C replace:
Income!C1
With:
C1
And to return an empty cell when the value returned by the formula is FALSE just add "" to the end of the formula. The formula should finally look like this:
=IF(ISNUMBER(SEARCH("13.99",C1)),"1","")
Do reply with result.
Your formula is close to what you want to do. To match the subsequent D cell with C replace:
Income!C1
With:
C1
And to return an empty cell when the value returned by the formula is FALSE just add "" to the end of the formula. The formula should finally look like this:
=IF(ISNUMBER(SEARCH("13.99",C1)),"1","")
Do reply with result.
MelyElly
Posts
3
Registration date
Wednesday November 21, 2012
Status
Member
Last seen
November 23, 2012
Nov 23, 2012 at 03:45 PM
Nov 23, 2012 at 03:45 PM
Thanks for trying to help. The C cell is referencing the first (Income) sheet, so that's why it has to stay "Income!C1." I'm just wondering how to make it automaticaly change to "Income!C2," etc. on the discounts sheet.
Do you know how?
Do you know how?