0

How can I convert this Excel Formula to SharePoint?

=IF(AND(F6="REG",G6>=4,G6<8),0.5,IF(AND(F6="REG",$G6>=8,G6<=16),1,IF(AND(F6="HDY",G6>=4,G6<8),1,IF(AND(F6="HDY",G6>=8,G6<16),1.5,0))))

Is there a way to convert this excel calculation to SharePoint?

New contributor
Vanessa is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
0

Create a column F6(Single line of text)

Create a column G6(Number)

Create a column calculate(Calculated) with the following formula:

=IF(AND(F6="REG",G6>=4,G6<8),0.5,IF(AND(F6="REG",G6>=8,G6<=16),1,IF(AND(F6="HDY",G6>=4,G6<8),1,IF(AND(F6="HDY",G6>=8,G6<16),1.5,0))))

enter image description here

Your Answer

Vanessa is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.