Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-03-2022, 10:36 AM
Jairoriele Jairoriele is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2020
Posts: 4
Jairoriele is on a distinguished road
Default Fórmula MS Project

Guys, I'm trying to apply a simple formula in the project, but I'm not having success:
IIf([Status]="Late";"1";IIf([Status]="Completed";"2";IIf([Status]="Due";"3";"4")))


It always accuses 4, as if it doesn't recognize the statuses. can anybody help me?
Reply With Quote
 

Tags
formula, status



Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphical indicator formula for MS Project Quinn87 Project 2 03-28-2021 11:38 PM
MS Project - RAG status formula imzkhan4 Project 0 11-13-2018 12:25 PM
Formula for cum work in Project 2003 pwhill Project 5 11-09-2014 03:22 PM
Formula To Calculate Countdown Days To Project Completion Catherine Project 1 02-19-2014 11:15 AM
Implementing excel formula in project nawab35 Project 6 08-04-2011 05:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft