I am trying to divide a cell IF GST is applicable to the transaction. I know I could buy or use accounting software.
My database bias is admitted.
=IF(E7=”Y”,B20/11,0)
Code is giving me a name
E7 is simple Yes/No field and is 'Y'
B20 in this case is 7451 number field
I thought the B20 /11 would give me 677.30. It gives me a 'NAME' result.
I have tried =sum(IF((E7=”Y”,B20/11,0)) and sumIF(E7=”Y”,B20/11,0)
Checked column B is formatted as Number as is Colum C where the formula and result are wanted.
- Forums
- General
- Divide IF in MS XLS ?
Divide IF in MS XLS ?
- There are more pages in this discussion • 2 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Featured News
The Watchlist
CCO
THE CALMER CO INTERNATIONAL LIMITED
Anthony Noble, CEO
Anthony Noble
CEO
Previous Video
Next Video
SPONSORED BY The Market Online