https://bugs.documentfoundation.org/show_bug.cgi?id=105323
raal <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
Severity|normal |enhancement
--- Comment #2 from raal <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
