Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

=HVIS(C5="ja";33,145833;37)

11 views
Skip to first unread message

Lars Carlsen

unread,
Mar 6, 2021, 9:30:54 AM3/6/21
to
Hej Gruppe

Kan jeg sætte et regneudtryk ind i formlen i stedet for 33,145833.
Jeg vil gerne have dette med i stedet:

(1680-175)/1680*37

Mvh. Lars

Jan Kronsell

unread,
Mar 6, 2021, 5:09:08 PM3/6/21
to
Ja:

=HVIS(C5="ja";(1680-175)/1680*37)

Jan

Lars Carlsen

unread,
Mar 8, 2021, 3:36:48 AM3/8/21
to
DOOH!!! Det virker - takker.

Jan Kronsell

unread,
Mar 8, 2021, 6:01:14 PM3/8/21
to
Velbekomme

Jan
0 new messages