EXCEL FORMULA

[philipmck]

= IF (A2288<>"", IF (RAW_DATA!B2288 > RAW_DATA!B2287, (RAW_DATA!B2287 + (50000–RAW_DATA!B2288), (RAW_DATA!B2288 – RAW_DATA!B2287) * 0.22)),"")

I have this formula in my database to do a calculation but it brings up an error box stating that " the formula i typed contains an error". What i am trying to do is to create a formula to do the following:

If (x1 > x2, = x2 + (limit - x1), x2 - x1)

In english this would be :

If x1 > x2
Then x2 + (limit - x1)
Else x2 - x1

PS thanks for your help in advance

 

[GlennUK]

Before going any further, tell us what is in Raw_Data!K2291 and Raw_Data!K2290 .

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[SkipVought]

philipmck,

I notice that you've been posting here at Tek-Tips for several weeks and have received many replies. If your experience has been anything like mine, some of those responses were valuable posts.

Furthermore, I noticed that you have never responded to any of these Tek-Tippers, to...
[blue]
Thank Tek-Tip Contributor
for this valuable post!
[/blue]
These little purple stars, that you've no doubt seen, are visible indicators of valuable information that many of us look for. They also act as "thank you's" to the person posting the tip. And finally, the identify the original poster, that's YOU, as someone who appreciates valuable information and is willing to make a visible expreession of that appreciation.

So please check back thru this thread and click the hyperlink at the bottom of the appropriate post or posts. Its a good habit!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}