# SharePoint using 4 individual IF formulas on one column.

40 Reputation points
2023-09-26T14:51:44.8033333+00:00

I have 4 columns each with a Yes/No value in it. What I want to do is have another column as a progress bar. Each column answered as Yes (True) will be worth 25% or just the number 25. If all 4 are True then the Progress bar value will be 100%.

In the progress bar column I am trying to use this Formula:

=IF([Application Form Completed?]="Yes",+25)

=IF([Application Form Sent?]="Yes",+25)

=IF([T's & C's Signed?]="Yes",+25)

=IF([References Checked?]="Yes",+25)

*Data returned as Number and shown and a percentage.

The issue is that each row is now displaying 100%, which isn't true.

I tried a combination of =IF(AND(IF(AND))... statements but that also proved to not work.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,830 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,569 questions

1. 23,936 Reputation points Microsoft Vendor
2023-09-27T02:21:09.54+00:00

Hi @Sergei Drew ,

I achieved your requirement by creating calculated column (the result of implementation is below).

Here are steps:

1.I created a calculated column named progress bar using the following formula（ Show as percentage）:

``````=(IF([Application Form Completed?]=TRUE,1,0)+IF([Application Form Sent?]=TRUE,1,0)+IF([T's & C's Signed?]=TRUE,1,0)+IF([References Checked?]=TRUE,1,0))/4

``````