Nov 11 2022 02:52 AM
Should be a simple formula, but I'm getting errors. I have a spreadsheet with numerical values that depend on each other. Example of a problematic formula: =IF(D4>G3,(D4-G3)*90%,0) does not work. E.g. values D4 = 1.30 and G3 = 0.875. Should be 0.3825. Else 0. Howto?
Nov 11 2022 03:05 AM
Nov 11 2022 03:26 AM
@OliverScheurichThank you very much. I done exactly the same as you, but receive a popup "It is a problem with this formula".
I have tried to copy a pic of my spreadsheet with the warning, but refuses (You have not rights to upload).
Nov 11 2022 03:31 AM - edited Nov 11 2022 03:32 AM
A closer look tell me that you have used =WENN instead of If. But that did not help me either. I use norwegian and WENN is not recognized, but IF is.
Nov 11 2022 03:38 AM
Solution=HVIS(D4>G3;(D4-G3)*90%;0)
This is the formula for Norwegian Excel.
=WENN(D4>G3;(D4-G3)*90%;0)
This is for german Excel. I didn't know which version you work with therefore i translated the formula into english.
Nov 13 2022 06:49 AM
Nov 11 2022 03:38 AM
Solution=HVIS(D4>G3;(D4-G3)*90%;0)
This is the formula for Norwegian Excel.
=WENN(D4>G3;(D4-G3)*90%;0)
This is for german Excel. I didn't know which version you work with therefore i translated the formula into english.