Suoritettu

I need an excel expert

I need the following formula to meet criteria,

"I need the ""main"" tab L22:EA333 to fulfil the following criteria

1) if the ""demand"" tab is 0 (no production), it will reflect as NA.

2) If the""projected inventory"" tab is > 0 (Positive), it will reflect the value in ""safety%"" tab.

3) If the""projected inventory"" tab is < 0 (negative), it will reflect the value as 0%

4) if the ""projected inventory"" tab is > 0 (Positive), and ""safety%"" is zero = NA"

Taidot: Excel, Tietojenkäsittely, Tiedonsyöttö, Visual Basic, Matematiikka

Tietoa työnantajasta:
( 0 arvostelua ) singapore, Singapore

Projektin tunnus: #30580182

Myönnetty käyttäjälle:

(265 Arvostelua)
7.0

6 freelanceria on tarjonnut keskimäärin $118 tähän työhön

(104 arvostelua)
5.8
(50 arvostelua)
5.4
Annmarie1995

Greetings, I hold a Master's degree in Business analytics making me a suitable person for your project. I have more than 5 years of professional experience in Data analysis. Besides, I have skills in Data Entry, Mathe Lisää

$120 SGD 3 päivässä
(22 arvostelua)
4.8
singhpam4

dear sir, i read this job's description and understand that i am perfect for this job.I have a lot of experience in this [login to view URL] you hire me for the project if you hire me , i can completed it very carefully and satisfi Lisää

$30 SGD 7 päivässä
(2 arvostelua)
0.4
snehasentrayan20

Respected hiring mam/sir, I would like to let you know that I'm a very hardworking & dedicated person . I only take payment when my clients smiles on my output . I'll do my work with full honesty. and also my educatio Lisää

$140 SGD 7 päivässä
(0 arvostelua)
0.0