Ask Your Question

Help with Calc Formula (Less or Greater than)

asked 2016-10-24 16:45:29 +0200

Xolture gravatar image

updated 2016-10-24 16:46:46 +0200

I've been trying to find a way to modify this formula into my needs.

for example:


Problem is,

the (C17*0.05) is has to be less or equal to 500000

and F12 has to be less or equal to 200000

I've tried to make it this way


But it didnt work.

Anybody who could help are greatly appreciated.


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-10-24 16:59:29 +0200

Lew Merrick gravatar image

Try: "=if((C140.05)<=500000),if((F12<=200000),SUM(((C17-(C170.05)-F12)12)-3600000)0.05)/12, "failure output")

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-24 16:45:29 +0200

Seen: 164 times

Last updated: Oct 24 '16