Ask Your Question
0

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:

=SUM((((C17-(C170.05)-F12)12)-36000000)*0.05)/12

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

=SUM((((C17-((C170.05)<=500000)-(F12<=200000)12)-36000000)*0.05)/12

But it didnt work.

Anybody who could help are greatly appreciated.

Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Stats

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

Seen: 164 times

Last updated: Oct 24 '16