Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Thomas Thomas is offline
external usenet poster
 
Posts: 35
Default Word Formula using IF

I have a small table with 4 or 5 fields that calculate based on the first
fields value. However, I need one field to calculate based on an IF
function.

I know how to write it in excel: =IF(SUM(H9*15%)1500,SUM(H9*15%),1500)

but how do I write something like this in Word? I need to write a formula
that can calculate 15% of the value in cell D1. If it is greater that 1,500,
place the calculated value in this field, if it is not greater than 1,500,
place 1,500 in this field.

Please Help

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formula in Word? Mercedes.K Microsoft Word Help 5 November 3rd 07 10:27 AM
Formula in Word jclplee Tables 1 October 31st 07 01:01 PM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM
formula in word Cheri Tables 8 July 5th 05 07:27 PM
Word formula - HELP! zSplash Tables 1 June 2nd 05 08:25 PM


All times are GMT +1. The time now is 01:44 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"