LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Please Help Again-Condition Formula

Can I please get additional help with the post that I posted earlier.
My first question was
If G37=daily, then F37 cannot be greater then 1. If it is greater then one,
then an error message will show in K37.

I received a correct answer for that question..
=IF(AND(G37="Daily",F37<=1),"OK",Error")

I didn't think that some items will be based on hourly rates and I will not
know what rolls will be that until the look up code picks up if it's a daily
or hourly item that I'm billing. (I have a billing codes that are based on
different rates that are picked up on another sheet, based on the code number
I use)

Can the formula have that if it's daily, that it will show the error if over
1, and if hourly it will not show an error if it's over 1?
Lordy mercy, I'm having a hard time even saying what I need it to show....I
hope someone will understand what I'm needing and respond....

Instead of lost in excel, I'm going to say dumb in excel.....
I would appreciate the help....
Thanks again.
Kareinia
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add Condition to Formula Karen Smith Excel Discussion (Misc queries) 2 December 21st 07 07:18 PM
MORE THAN ONE CONDITION IN A FORMULA CLM Excel Worksheet Functions 5 January 18th 07 01:21 PM
Formula For If & Or Condition anandmr65 Excel Discussion (Misc queries) 8 April 17th 06 10:40 AM
If formula and #N/A as a condition EstherJ Excel Discussion (Misc queries) 2 August 23rd 05 02:52 PM
HELP? ...a second condition in one formula MichaelTM99 Excel Worksheet Functions 5 December 3rd 04 10:29 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"