https://bugs.documentfoundation.org/show_bug.cgi?id=105323
raal <r...@post.cz> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |r...@post.cz
Severity|normal |enhancement
--- Comment #2 from raal <r...@post.cz> ---
compared to excel
N4=0.087
excel
=IF(H4=0;" ";INDIRECT((ADDRESS((ROW()-$B4);14;2)))*H4)
delete I
=IF(H4=0;" ";INDIRECT((ADDRESS((ROW()-$B4);14;2)))*H4)
delete G
=IF(G4=0;" ";INDIRECT((ADDRESS((ROW()-$B4);14;2)))*G4)
result 0.180
calc
=IF(H4=0," ",INDIRECT((ADDRESS((ROW()-$B4),14,2)))*H4)
delete I
=IF(H4=0," ",INDIRECT((ADDRESS((ROW()-$B4),14,2)))*H4)
delete G
=IF(G4=0," ",INDIRECT((ADDRESS((ROW()-$B4),14,2)))*G4)
result 0.180
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs