IF statement with %

[Shmulikf]

Cell 1: 250,000
Cell 2: 85%
Cell 3: 80%
Cell 4: _____


For cell 3 I want it to do:
"if cell2 is >cell3 then let cell4 = cell2 * cell1. If cell2 is <cell3 then let cell 4 = 0"

 

[Shmulikf]

For cell 4 I want it to do:
"if cell2 is >cell3 then let cell4 = cell2*cell1. If cell2 is <cell3 then let cell4 = 0"

 

[Shmulikf]

something is going wrong with saving.....

For cell 4 I want it to do:
"
if cell2 is >cell3 then let cell4 = cell2 * cell1.
If cell2 is <cell3 then let cell4 = 0
"

 

[Shmulikf]

For cell 4 I want it to do:
"
if cell2 is greater then cell3 then let cell4 = cell2 * cell1.
If cell2 is less then cell 3 then let cell q4 = 0
"

 

[Tetra201]

For cell 4 I want it to do:
"
if cell2 is greater then cell3 then let cell4 = cell2 * cell1.
If cell2 is less then cell 3 then let cell q4 = 0

And if cell2 is equal to cell3?

 

[Shmulikf]

should act the same as if cell2 is greater then cell 3.

 

[Tetra201]

Try putting the following formula in cell A4:

=IF(A2 < A3,0,A2*A1)

 

[Shmulikf]

WORKS! thank you

 

[Tetra201]

You are welcome.