Hi
I am preparing a spreadsheet where I want the amount entered and categorised on the left to automatically transfer to the classification area
my formula is
=IF(ISNA(Sheet1!$C4),0,LOOKUP(2^15,SEARCH(E$3,$D4),$C4))
Started with just the lookup which worked well but put all transactions on the first line.
line one if there is income from services then return $1000. all other cells should be zero or blank
I don't how to use macros for this.
this how the spread sheet looks
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
have tried if(not(isna, if(1-ISNA... all say too many variables in the formula
slowing going mad.
any and all help greatly appreciated.
Thanking you in advance.
I am preparing a spreadsheet where I want the amount entered and categorised on the left to automatically transfer to the classification area
my formula is
=IF(ISNA(Sheet1!$C4),0,LOOKUP(2^15,SEARCH(E$3,$D4),$C4))
Started with just the lookup which worked well but put all transactions on the first line.
line one if there is income from services then return $1000. all other cells should be zero or blank
I don't how to use macros for this.
this how the spread sheet looks
Classification | ||||||
date | narration | Amount | account | Income from service | drawings | sinking find |
1/02/2013 | sales | 1000 | income from services | 1000 | #VALUE! | #VALUE! |
1/02/2013 | drawing | -600 | drawings | #VALUE! | -600 | #VALUE! |
1/02/2013 | ||||||
1/02/2013 | ||||||
1/02/2013 |
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
have tried if(not(isna, if(1-ISNA... all say too many variables in the formula
slowing going mad.
any and all help greatly appreciated.
Thanking you in advance.