SOLVED

# IF statement

Occasional Contributor

# 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. values D4 = 1.30 and G3 = 0.875. Should be 0.3825. Else 0. Howto?

5 Replies

# Re: IF statement

``=IF(D4>G3,(D4-G3)*90%,0)``

Works as intended in my sheet.

# Re: IF statement

@Quadruple_PawnThank 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).

# Re: IF statement

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.

best response confirmed by xlarge2 (Occasional Contributor)
Solution

# Re: IF statement

``=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.