IF the great IF...

[Pierre Fourie]

Hi everyone,

I need some help, i'm feeling brain dead here... i am facing a challenge in formulation and can not get it right... please view the attached sample file.

In column F i need to calculate a value. but column E verifies the values in column A and provides another value accordingly.

Column C then gets multiplied with column E (formulae inside column F) the get the value for column F.

However it does not seem to work right as i get a #value! error as soon as the value of column C is greater than 0.

That is the purpose, to calculate the value if greater than 0...

Please help, my small brain does not seem to want to work any more...

Regards

Pierre

 

[Pierre Fourie]

shucks i forgot the file...

 

[NARAYANK991]

Hi ,

I don't see any problem other than use of text outputs instead of numeric , use of Text cell formats ,...

See the attached file.

Narayan