Forum Discussion
Solved
IF statement
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...
=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.
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).
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.
=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.
