Thread: Urgent (University) Please Help m with an EXcel Function

Hi Guys,

I have just joined this forum as i really need help urgently with an excel function.
Basically Iv got Column A with angles between 0 and 1.56 radians. These angles are generated randomly, so it can be 0.22, 0.56,1.55 etc etc...Now in column B Iv got to carry out a function. The function is =43.22/COS(AX) X depends on the corresponding value in column A.

Every thing is fine up to here and I can do it...BUT I only need to carry out the function if the angle in Column A is smaller than 1...And if the value is bigger than 1 it only needs to output a value of 80. Thats it so...depending on the value in column A it will either carry out =43.22/COS(A) OR just make it show =80.

I hope i have explained this well enough and please let me know if need any more information. Thanks a lot in advance.

Hello aaronjason,

You've also broken another rule . If you post the same question to another forum (i.e "crosspost") you should provide a link

I thought since it was on an other website It would be better to add it to you forum too. But I have also got another question..I have updated the cross post so i will not post here.