Forum Discussion
Solved
QuattroPro to Excel Formulas
I am trying to convert a spreadsheet from QuattroPro to Excel. Saving as an Excel worksheet from QuattroPro doesn't work nor does coping and pasting formulas. I have entered most formulas into Excel format but am having problems with the following:
@IF(AA6>40,0,@IF(40-AA6>=8#AND#K6>=8,8,@IF(40-AA6>=8,K6,@IF(40-AA6<=K6,40-AA6,K6))))
@IF(AU6=1#AND#M6>30,0,@IF(AC6>40,0,@IF(40-AC6>=8#AND#L6>=8,8,@IF(40-AC6>=8,L6,@IF(40-AC6<=L6,40-AC6,L6)))))
@IF(AU6=1#AND#L6>8,L6-8,0)
Would appreciate a translation if possible.......
- I believe this is what they would translate to:
=IF(AA6>40,0,IF(and(40-AA6>=8, K6>=8),8,IF(40-AA6>=8,K6, IF(40-AA6<=K6,40-AA6,K6))))
=IF(AND(AU6=1, M6>30),0,IF(AC6>40,0,IF(AND(40-AC6>=8, L6>=8),8,IF(40-AC6>=8,L6,IF(40-AC6<=L6,40-AC6,L6)))))
=IF(AND(AU6=1, L6>8) ,L6-8,0)
But, Excel does have an IFS function that could be used instead of nested IF functions for the first two. I believe it would be:
=IFS(AA6>40, 0, AND(40-AA6>=8, K6>=8), 8, 40-AA6>=8, K6, 40-AA6<=K6, 40-AA6, TRUE, K6)
=IFS(AND(AU6=1, M6>30), 0, AC6>40, 0, AND(40-AC6>=8, L6>=8), 8, 40-AC6>=8, L6, 40-AC6<=L6, 40-AC6, TRUE, L6)
2 Replies
- I believe this is what they would translate to:
=IF(AA6>40,0,IF(and(40-AA6>=8, K6>=8),8,IF(40-AA6>=8,K6, IF(40-AA6<=K6,40-AA6,K6))))
=IF(AND(AU6=1, M6>30),0,IF(AC6>40,0,IF(AND(40-AC6>=8, L6>=8),8,IF(40-AC6>=8,L6,IF(40-AC6<=L6,40-AC6,L6)))))
=IF(AND(AU6=1, L6>8) ,L6-8,0)
But, Excel does have an IFS function that could be used instead of nested IF functions for the first two. I believe it would be:
=IFS(AA6>40, 0, AND(40-AA6>=8, K6>=8), 8, 40-AA6>=8, K6, 40-AA6<=K6, 40-AA6, TRUE, K6)
=IFS(AND(AU6=1, M6>30), 0, AC6>40, 0, AND(40-AC6>=8, L6>=8), 8, 40-AC6>=8, L6, 40-AC6<=L6, 40-AC6, TRUE, L6)
