If in VB Format

[gmazza76]

I am using a sum as follows to grade an result on the quality info that I have been building for so long, but I have been asked to change it slightly<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
=IF(S1<19,S2,IF(S1<22,S3,IF(S1<26,S4,S5)))<o></o>
<o> </o>
S2 = Feels like I haven't done enough<o></o>
S3 = Feels like I have just done enough<o></o>
S4 = Feels Like I care<o></o>
S5 = Extra Mile<o></o>
<o> </o>
Is there anyway using VB that I can get the above sum done, but if cell K78 or K94 = No, or R59 < 3 then “Feels like I haven’t done enough” is populated in G4. If these are ok then the sum above is run with the outcome to be posted in G4.<o></o>
<o></o>
<o>The only thing i am unsure about is would this be better written in a module or in the worksheet. </o>
<o></o>
Hopefully this makes sense.
Many Thanks
Gavin

 

[Andrew Poulsom]

Why do you need VBA for that?

=IF(OR(K78="No",K94="No",R59<3),S1,IF(S1<19,S2,IF(S1<22,S3,IF(S1<26,S4,S5))))

 

[SteveO59L]

What make you think you need a vb solution?

 

[gmazza76]

Thanks

I am useless at doing formulas, especially if statements as i always seem to have errors.

Again Many Thanks