Excel formula
Solved/Closed
Related:
- Excel formula
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel apk for pc - Download - Spreadsheets
1 response
This satisfies your scope:
Whatever value is in cell C8, it will display in D8, as long as H8 contains the text "Mastercard"! Try using lower(H8)="mastercard".
Or you could actually, link the test word, to cell A1, as in:
=if(H8=lower(A1),C8)
Then what ever is in cell A1 will be the keyword to match for!~
Have FUN!
It's kind of fun to do the impossible! -Walter Elias Disney
Whatever value is in cell C8, it will display in D8, as long as H8 contains the text "Mastercard"! Try using lower(H8)="mastercard".
Or you could actually, link the test word, to cell A1, as in:
=if(H8=lower(A1),C8)
Then what ever is in cell A1 will be the keyword to match for!~
Have FUN!
It's kind of fun to do the impossible! -Walter Elias Disney